Is there is a way to not allow a user to see the Row and Column Headings (Tools Options View) and to not allow a user to check the box to see the Row and Column Headings. In other words - create a spreadsheet where the user can never see the row and column headings.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Lock Out Viewing Row and Column Headings
- Thread starter Romary
- Start date
SkipVought
Programmer
Romary,
It can be done, but it will not be MS Excel.
;-)
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
It can be done, but it will not be MS Excel.
;-)
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
VBA code can be written that on open of the workbook, the menus are removed and the columns and rows are hidden from view. However, VBA is not fail-safe or un-crackable. So it depends on your purpose.
Anne Troy
VBA Coders, please help:
Anne Troy
VBA Coders, please help:
SkipVought
Programmer
Anne et al,
A savy user can STILL use KEYBOARD SHORTCUTS to access ANY MENU in ANY MS APPLICATION , regardless if the menu is visible or not!
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
A savy user can STILL use KEYBOARD SHORTCUTS to access ANY MENU in ANY MS APPLICATION , regardless if the menu is visible or not!
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
- Status
Similar threads
- Locked
- Question
- Locked
- Question