Thread: Lock Screen
View Single Post
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

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
"Duncan" wrote in message
...
|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