View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ALEX ALEX is offline
external usenet poster
 
Posts: 493
Default Macro Prompt for Zoom size

I use Excel 2000 and have several worksheets that run on several computers.
The screen pixel size tends to vary with users, so for some users my
worksheets will spill over the screen. How would a macro be written that
prompts the user for a zoom % so they can change the worksheet view w/o
having to go through the command steps. I use buttons for my macros, but do
not know VB.

Alex