ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hide/Unhide after protect sheet (https://www.excelbanter.com/excel-discussion-misc-queries/180860-hide-unhide-after-protect-sheet.html)

RKS

Hide/Unhide after protect sheet
 
Hi All,

I have excel sheet. I can protect some cell so user can change formula.

Point 1 : - I can group some column and in view code I can write code and
protect sheet
its wrking fine. I want dont use password in code. I need give password
manually. pl correct my code.

Private Sub Workbook_Open()
With Worksheets("sheet1")
.EnableOutlining = True
.Protect Password:="password", _
Contents:=True, UserInterfaceOnly:=True
End With
End Sub


Point 2 :- I want user can manually hide/unhide row and column my protected
sheet. pl tell me what code I can write and where.

point 3 :- I wants create print command button. when we click print the
sheet and also print another sheet.
pl tell me what code I can write and where.

point 4 :- I wants create Find command button so user can find. pl tell me
what code I can write and where.

PLease help me urgently
Thanks in advance
RKS



All times are GMT +1. The time now is 08:32 AM.

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