ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lock Screen (https://www.excelbanter.com/excel-discussion-misc-queries/38248-lock-screen.html)

Duncan

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

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
"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




All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com