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

Macro Prompt for Zoom size
 

This would probably be the easiest... Add this line to a macro

Application.Dialogs(xlDialogZoom).Show
--
HTH...

Jim Thomlinson


"Alex" wrote:

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

Macro Prompt for Zoom size
 

Thank you very much, it works great. I knew there had to be a simple way,
didn't think 1 code line would do it though. :)

Alex

"Jim Thomlinson" wrote:

This would probably be the easiest... Add this line to a macro

Application.Dialogs(xlDialogZoom).Show
--
HTH...

Jim Thomlinson


"Alex" wrote:

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