asked on macro to set zoom properties of each tab
Hi Experts using excel 2010
Need a macro to set the zoom into worksheet tab properties of each to to as follows
1. Sheet 1 = 80%
2.sheet 2 = 110%
3 sheet 3 = 70%
4. Sheet 4 = 50%
Need a macro to set the zoom into worksheet tab properties of each to to as follows
1. Sheet 1 = 80%
2.sheet 2 = 110%
3 sheet 3 = 70%
4. Sheet 4 = 50%
Microsoft Excel
Last Comment
aikimark
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi Experts...I added this.code to the module..Thisworkbook and not working...
1. is your workbook macro enabled? (file extension = XLSM)
2. Did you place the code inside a SUB...END SUB structure?
3. How are you invoking the code?
2. Did you place the code inside a SUB...END SUB structure?
3. How are you invoking the code?