Auto run a macro in Excel- can you call other procedures/macros from this 'Private Sub Workbook_Open

%3CLINGO-SUB%20id%3D%22lingo-sub-2029243%22%20slang%3D%22en-US%22%3EAuto%20run%20a%20macro%20in%20Excel-%20can%20you%20call%20other%20procedures%2Fmacros%20from%20this%20'Private%20Sub%20Workbook_Open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2029243%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20run%20a%20macro%20when%20my%20Excel%20workbook%20is%20being%20opened.%20This%20macro%20is%20changing%20some%20screen%20settings%20(ribbon%20off%2C%20headings%20off%20etc.).%20It%20does%20that%20by%20calling%20other%20macros%20(say%20one%20for%20headings%20off%2C%20one%20for%20status%20bar%20off%20etc.).%3C%2FP%3E%3CP%3EIn%20principal%20it%20does%20all%20this%20at%20opening%20and%20there%20are%20no%20errors%20when%20I%20run%20this%20macro%20stepwise%20with%20F8%20and%20when%20it%20runs%20automatically.%20But%20then%2C%20after%20ribbon%2C%20headings%20etc.%20are%20off%20I%20have%20a%20command%20%3A%3C%2FP%3E%3CP%3E'Worksheets(%22Start%22).Select%20Range(%22A1%3AY52%22).Select%26nbsp%3B%3CBR%20%2F%3EActiveWindow.Zoom%20%3D%20True%3C%2FP%3E%3CP%3EThis%20seems%20not%20to%20work.%3C%2FP%3E%3CP%3EIf%20I%20run%20this%20as%20an%20extra%20macro%20the%20screen%20reacts%2C%20but%20not%20as%20part%20of%20the%20%22Workbook_Open%22-macro.%20Can%20anybody%20help%3F%20Thanks%20in%20advance%2C%20LuBu%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2029243%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I need to run a macro when my Excel workbook is being opened. This macro is changing some screen settings (ribbon off, headings off etc.). It does that by calling other macros (say one for headings off, one for status bar off etc.).

In principal it does all this at opening and there are no errors when I run this macro stepwise with F8 and when it runs automatically. But then, after ribbon, headings etc. are off I have a command :

'Worksheets("Start").Select Range("A1:Y52").Select 
ActiveWindow.Zoom = True

This seems not to work.

If I run this as an extra macro the screen reacts, but not as part of the "Workbook_Open"-macro. Can anybody help? Thanks in advance, LuBu

 

0 Replies