Monday, 15 September 2014

excel - Workbook_Open event changes other workbooks -


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