How to zoom sheet particular to 80% using VBA on closing?

A

Azuki

Board Regular
Joined
Feb 14, 2013
Messages
73
When user close the file, I want to make sure certain sheets can zoom to 80%. How can this be done using VBA?
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Sort by date Sort by votes
Code: 
Sheet1.activate
ActiveWindow.Zoom = 80
Sheet2.activate
ActiveWindow.Zoom = 80


which is the certain sheets? just activate the sheets.
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question
Excel only opens correctly when zoom is set to 100%
Replies
2
Views
383
jls9874
J
SanjayGMusafir
  • Solved
VBA to Jump to the last row excluding blanks
Replies
5
Views
229
Joe4
Joe4
T
  • Solved
Automatic zoom when new sheet opened
Replies
3
Views
323
rollis13
rollis13
C
  • Question
Formatting issue - Space being inserted above some word wrapped cells with autofit - not the same cells as print preview
Replies
0
Views
464
CBme
C
M
  • Solved
VBA to Convert and Merge .PNG to .PDF
Replies
2
Views
640
michele227
M

Forum statistics

Threads
1,203,490
Messages
6,055,726
Members
444,814
Latest member
AutomateDifficulty

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top