VBA: Unhide Very Hidden Sheet

[bamaisgreat]

I sheet 9 very hidden. How can i adjust code so it will run properly.
Thanks as always

Sub unhide_9()
'
' unhide_9 Macro
'
    With Worksheets("Sheet9")
        .Visible = xlSheetVisible
        .Select
        Application.Wait Now + #12:00:12 AM#
        Worksheets("BURN").Select
        .Visible = xlSheetHidden
    End With
    
End Sub

 

[bamaisgreat]

I will give that a try. Thanks for the help....

 

[bamaisgreat]

Ok, I have Run into another problem with this. I have the code below in the Worksheet code

Private Sub Worksheet_Change(ByVal Target As Range)
If Target(1).Value = "Final" Then Call SHOW_7
End Sub

after that this code runs

Sub SHOW_7()
'
' SHOW_7 Macro
'
'
'
With Worksheets("Sheet7")
.Visible = xlSheetVisible
.Select
Application.Wait Now + #12:00:05 AM#
Worksheets("BURN").Select
.Visible = xlVeryHidden
End With

End Sub

I need the code to delete the word "Final" when it finishes

 

[erik.van.geit]

try this

Private Sub Worksheet_Change(ByVal Target As Range)
    With Target(1)
        If .Value = "Final" Then
        Call SHOW_7
        Application.EnableEvents = False
        .Value = ""
        Application.EnableEvents = True
        End If
    End With
End Sub

If you want more help, tell us in what module this code is located. (is it for the sheet "BURN"?)

 

[Cemslie87]

hi,

Love this website! It has some great hints and tips for us newbies to VBA.

Could someone please point me in the right direction of code that would allow only certain user profile names to automatically access the very hidden worksheets when they open the document? When non authorised users open i would like them to see certain worksheets but not, obviously, the very hidden ones.

I hope this makes sense and that it isnt too much hassle to write.

TVM,
CE

 

[erik.van.geit]

Hello
Welcome to MrExcel!

You replied to an old thread, which is not a very good idea. (In fact you're lucky that I saw it already now.)
You could do a search for "password" & "users" or something like that. If you can not find what you want, you can start a new thread. You could insert some links to other threads for reference. At the moment I can't really spent much time here.

kind regards,
Erik