I have the code below in the workbook module:
private sub workbook_on () application ExecuteExcel4Macro "Show.ToolBar (" "Ribbon" ", false)" application. DisplayFormula = False application. Display Statsubbar = Application Not DisplaysStatusbar ActiveWindows DisplayBookbab = false activation window DisplayHeightings = Incorrect Apps. WorldTest = XLMaximated ActiveSheet.UsedRange.Select ActiveWindow Zoom = True Range ("A1"). Choose the end
But when I open the workbook in question, the code settings are applied to all other workbooks that have been opened. How can I limit the settings of the code to apply only to workbook in question? Best Relationship
Edit: This solution does not work for me either:
Private sub workbook_on () with me the application. Vindostat = Select the XLMaximated ActiveSheet.UsedRange.SelectWindowSelect.Zoom = True Range ("A1"). Choose application Extexxcel 4 macro "Show Tools (" "" Ribbon "," false) "application DisplayFormulabar = Incorrect application Displaystatsbar = application not DisplayStatusBrowserWindows DisplayBookbab = false activation window DisplayHeal = False End Sub End
Try it, with me After this, open the Private Sub Workbook with the personal sub workbook_on ()
such as
'all other codes end with the end
worked here
No comments:
Post a Comment