Lock Screen

D

Duncan

I have a menu screen in excel with macro buttons and text. can you make it
so the cursor cannot be moved around the screen.

I hvae tried protecting the sheet bit this seems to stop some of the macro
buttons from working.

many thanks
Duncan
 
J

Jim Rech

The only way may be to protect the worksheet, disallowing selecting any
cells (an option in Excel 2002 and 2003, which I assume you have). Buttons
will work on a protected sheet but you may have to do some recoding. For
instance any code that does a "select" will obviously not work.

--
Jim
|I have a menu screen in excel with macro buttons and text. can you make it
| so the cursor cannot be moved around the screen.
|
| I hvae tried protecting the sheet bit this seems to stop some of the macro
| buttons from working.
|
| many thanks
| Duncan
 
Top