sheets hide

  1. D

    Blocking acess to some sheets

    Hello people I have a workbook with some sheets. The user can acess some sheets, but other sheets are "secret". There's no buttons to acess these sheets, but if the user uses the shortcuts CTRL+PGDOWN or CTRL+PGUP is possible. I want to block the acess to some sheets. How could I do that?
  2. H

    How to run Solver while viewing a graph? (not the sheet the solver problem is located in)

    Problem: How to run Solver while viewing a graph? (windows XP, Excel 2003) The outset: I am running a complex solver problem (typically takes a couple of minutes to hours) the results are then fed into the 20 or so cells solver may change. These cells compute a graph in the same workbook...
  3. D

    Hiding Sheets with VBA

    I have read posts similar to this but not quite what I need. I have a workbook with 40 sheets. 15 of these sheets I would like to be able to hide/unhide them by running a macro. All 15 of the sheets have names ending with "bill". Any suggestions on how to choose sheets based on a part of the...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top