| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to make a sheet viewable but not selectable?
I have a work book with multiple sheets. I want the user to be able to
select sheet 1 to access macro buttons. I want them to be able to view the results of the macro data entries on sheet 2, but I do not want them to be able to directly modify or even select sheet 2, only view the entered data. I can't simply protect the worksheet, because new data is being added and old data changed. I tried changing the worksheet properties in VBA, EnableSelection to "No Selection", but that did not seem to have an effect. Help? Is this possible? -Bill |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I make a worksheet protected, locked AND not viewable? | Excel Discussion (Misc queries) | |||
| Can I make rows of an excell spreadsheet 'selectable' (on/off)? | Excel Worksheet Functions | |||
| How do I make a line non-selectable? | Excel Discussion (Misc queries) | |||
| How to make Add-In worksheets viewable. | Excel Programming | |||
| Write data to a cell, then make it undeletable/selectable | Excel Programming | |||
Threaded Mode
