unhiding

  1. D

    VBA copy sheet as hidden

    Hi, Is possible to copy a hidden sheet from one workbook to another without unhiding the hidden sheet? I have been looking for a solution to this but can't seem to come up with anything without unhiding, copying then hiding the sheet. Can someone help with this please
  2. D

    Excel crashing on Copy / Paste

    Hello All, A workbook I developed is crashing on a vanilla copy/paste. At bit of background: * No VBA * Issue happens whether I use toolbar or shortcut keys * I have tried: (i) copying to another workbook; (ii) removing conditional formatting; (iii) unhiding and ungrouping rows and columns...
  3. L

    Finding a number in a row based on a Week number and unhiding the column it appears in

    So I've been trying and failing for days at trying to work this out. Basically I need the code to look at the Headlines tab and reference E7 (Weeknumber) and find that week number in Row 46 on the 'Part' tab, and unhide the column that has the weknumber in row 46.. Please someone help :(
  4. W

    Force Enable Macros

    I also am trying to force users to enable macros, but the VBA code that I found searching Google conflicts with my cases for each worksheet. I thought a better alternative might be initially hiding (using VeryHidden) all the worksheets except my menu and then forcing the user to enter the...
  5. D

    Unhiding a row automatically if text is returned

    I need some assistance please. I am running a vlookup function that returns text to a specified cell if the value my vlookup is referencing appears. I have several vlookups in column "A" of worksheet 1 that reference data in column "A" of worksheet 2. In worksheet 1, there is always a list of...

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