ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   secure a sheet (https://www.excelbanter.com/excel-programming/281419-secure-sheet.html)

solo_razor[_25_]

secure a sheet
 

hello,

I want to secure a sheet so that it can nog be accessed below but only
with buttons placed in a field.

Does anybody know how this can be done

Regards,
Niek


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/


Jim Rech

secure a sheet
 
You could 'very hide" / unhide it with code:

Sheet1.Visible = xlSheetVeryHidden

Sheet1.Visible = xlSheetVisible

--
Jim Rech
Excel MVP




All times are GMT +1. The time now is 01:30 PM.

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