sheet hidden

  1. 2

    Renaming and hidding a sheet after taking value from a changing cell

    Hello, I have a drop down menu (in cell E6) with the following options: empty, apple, banana, pineapple. The menu is placed in a sheet called "Start". It is already assigned that when the option is empty number 1 is assigned, for apples is 2, for bananas is 3 and for pineapple is 4. It takes...
  2. G

    How do I create a macro to show/hide several worksheets in my displayed list?

    I have 4 really great Macro's that I need some help tying together. One macro looks at all the tabs in my workbook and creates an Index tab showing all the sheet names within the workbook and creates a hyperlink to each of those sheets. The macro also gives the option to add a hyperlink on...
  3. B

    VBA: Show timer on sheet then hide sheet

    I have a sheet named SEND FORM that has some info that I would like for the user to see for about 10sec when he opens the work book and then it will hide and show the sheet they will be working in named STOCK CUTTING FORM.. Also is it possible to have the 10 sec timer to be shown in cell L12 in...
  4. D

    VB use of field text to select & execute macro

    I need to select and unhide a sheet based on the the text that is input and stored in a spreadsheet. I have four options that will be stored in a sheet called MENU. The options are: Automotive, Industrial, Life_Sciences, Electronics. Based on the field selection in the cell h9 I want to...
  5. J

    Selected Sheet Hidden; ERROR can't run macro

    I have several sheets that need to have an application run, but only if it is not hidden. This is what I currently have and the macro stops to debug when it the sheetX is hidden. Sheet5.Select Application.Run _ "'Program Spend Statement - Master Template.xls'!RemoveAndClear"...

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