Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excell zoom 2

Status
Not open for further replies.
simoncpage

simoncpage

Programmer
Apr 4, 2002
256
GB
Hi all, Does anyone know how I can capture the zoom % of a sheet?

Thanks

Simon
 
Sort by date Sort by votes
I know of this - what I want to do is find out what the current sheet zoom factor (%) is

thanks

 
Upvote 0 Downvote
I don't see what the difference is. Why wouldn't the activewindow.zoom property give you that information?
Rob
 
Upvote 0 Downvote
MyZoom = activewindow.zoom

HTH Rgds
~Geoff~
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

davefish
  • Locked
  • Question
Excel Sheet view zooms in slightly when running code
Replies
0
Views
60
davefish
davefish
jhabey01
  • Locked
  • Question
Excell VBA to Format Worksheet
Replies
2
Views
67
SkipVought
S
Deniall
  • Locked
  • Question
Has J P Software's excellent VBA Search Engine been closed down?
Replies
1
Views
76
MakeItSo
MakeItSo
Gav42
  • Locked
  • Question
Determine PageSetup Zoom Value When Fit To is Selected and related issues
Replies
1
Views
45
combo
combo
MichaelintheUK
  • Locked
  • Question
Using Excel zoom window from Access VBA 1
Replies
2
Views
67
MichaelintheUK
MichaelintheUK

Part and Inventory Search

Sponsor

Back
Top