show hidden worksheet

[LFKim2018]

I have a "VERYHIDDEN" worksheet named "prov" in a workbook and I want to show and browse it without editing option - just view - with the assigned keys > say, Ctrl + P or Ctrl + V to open it and after closing - the said worksheet to return to the original view setup (veryhidden)
how would the vba be written?
Thank you

 

[Trebor76]

Hi LFKim2018,

Here are the two macros you need:

Option Explicit
Sub VeryHiddenUnhide()

    Sheets("prov").Visible = xlSheetVisible

End Sub
Sub VeryHidden()

    Sheets("prov").Visible = xlSheetVeryHidden

End Sub

Keep in mind that Ctrl + P is Excel's print option default while Ctrl + V is its pasting default. Assigning custom code to those shortcuts will stop that from happening which could confuse users who are used to using shortcut keys.

HTH

Robert

 

[LFKim2018]

Thank you for early reply
ok, so Ctrl+P & Ctrl+V are assigned --- say we use Ctrl+non-assigned letter or char
I would like to save this command to "the Workbook" vba - what could be the macro?
Thank you again

 

[Trebor76]

You can run either macro from the Macro dialog (Alt + F8) or if you want to use shortcut keys perhaps Ctrl + Shift + A and Ctrl + Shift + B for the two macros.

 

[LFKim2018]

Thank you very very much for your time

 

[Trebor76]

You're welcome. Glad we got it sorted

 

[LFKim2018]

if it is not too much to ask for your help again
in the workbook I created for costing - it consists of several worksheets - and one of that is the template - it is worksheet protected but user can input data to it. But when I used Ctrl key and drag it to the right with mouse pointer at the sheet - it duplicated the worksheet even though it is protected - I would want to know if I can deactive this COPY SHEET function only for that specific sheet named "Form". using workbook protect would not do as it freezes all worksheets - the whole workbook for that matter.
what would be the macro for this..
Thank you very much

 

[Trebor76]

Though you should start a new thread for each new question see if the code here helps.