xlveryhidden

  1. G

    Error in WorkBook_Open code: Activate method of Worksheet class failed

    Hi Falks, I have written a code in workbook module in a file with Workbook_Open activity and I am receiving the below error while I am opening the file from sent email or sometimes from main file. Can anyone help me to resolve the below error...
  2. P

    Run time error 91 - Object Variable or With block variable not set

    Hello all, I am opening up a workbook which, the workbook module has not changed but all of a sudden I am getting above error message, this happens upon opening. I can click end and it gives me no option to debug The open code is as follows Private Sub Workbook_Open()...
  3. R

    Keyboard shortcut not working for a macro

    I'm having trouble getting a macro to run when I press a key combination. This code sets the worksheets to VeryHidden: Sub DeliveryPrep() Worksheets("Leader Info").Visible = xlVeryHidden Worksheets("Calculations").Visible = xlVeryHidden Worksheets("Details").Visible =...
    • rizzo93
    • Thread
    • macro shortcut worksheetsleader xlveryhidden xlvisible
    • Replies: 3
    • Forum: Excel Questions
  4. D

    VBA xlVeryHidden Specific Worksheets

    I have some code that will loop a range and copy worksheets. Each of the sheets with *Data in the name needs to be hidden. Any suggestions? For j = 1 To n ThisWorkbook.Sheets(j).Copy After:=Wkb.Sheets(j) On Error Resume Next Set Target = Nothing...
    • daveasu
    • Thread
    • after=wkb.sheetsj thisworkbook.sheetsj.copy vba xlveryhidden worksheets xlveryhidden
    • Replies: 1
    • Forum: Excel Questions
  5. D

    VBA Help with xlveryhidden

    Hi, I have been tasked with cleaning up an old add in, however the Issue is that I have set the xlveryhidden sheets to xlvisible in the VBE but they are still not visible, I have also tried to unhide the sheet afterwards but all I can see is the standard sheet 1-3 tabs. Have I missed something?
  6. B

    i want to use xlveryhideen

    i have 2 shees which i need to use "xlveryhidden" Macro There is a issue with using it 1st sheet=input1 2nd sheet input2 This sheet are linked to other sheets with macro,if two sheets are visible then macro is running properly Sub Boom() Sheets("SheetName").Visible = xlVeryHidden...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top