| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Lock Screen
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make a splash screen appear first | Charts and Charting in Excel | |||
| How do I move the current cell to the top of the screen? | Excel Discussion (Misc queries) | |||
| Worksheet won't display full screen | New Users to Excel | |||
| Run-time error after screen lock in XP | Excel Discussion (Misc queries) | |||
| Screen Updating | Excel Worksheet Functions | |||
Linear Mode
