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...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    • Started by Unexpc
    • Replies: 39
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
  • IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
    • Started by IDRIS86
    • Replies: 25
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    • Started by DEllis
    • Replies: 21
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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