veryhidden

I've got a Workbook report that pulls 'raw' source data in via MS Query. I don't want the report recipients to see this RAW DATA and also some other 'helper' worksheets so I've set those to be VeryHidden. Since there are a large number of other visible sheets, I've copied a macro which produces...

I have a macro which opens a couple of "template" analysis files (both very similar) and a data file. It then copies the data into one of the template file in the "Sheet" worksheet. There are also a number of hidden 'calculation' worksheets and a "summary" worksheet in the template file...

To start, I have no idea how to write or run macros. I know that I want to have 37 of the 39 sheets in a file I made to be VeryHidden so they are as protected as possible when the workbook is opened, with a prompt to enter a password to reveal the sheets. I've seen macros that I guess have...

I have a "VERYHIDDEN" worksheet named "prov" in a workbook and I want to show and browse it without editing option - just view - with the assigned keys > say, Ctrl + P or Ctrl + V to open it and after closing - the said worksheet to return to the original view setup (veryhidden) how would the...

Hi, I have several sheets that are I have set to become veryhidden when closing my workbook. I have a macrobutton that I can press, and it will unhide the sheets. Can I somehow create a password that I have to enter when pressing the macro to unhide the sheets?

I am new to Exel and have been dropped in the deep end with my new job and although my learning curve has been steep there are a couple of things I urgently need to do and I am confused to hell! And I quite like my job so please can anyone help me!? I am working on a large work book about 20...

Hey All,</SPAN> I came to a fancy idea, but I got stuck while trying to get it together. The basic problem is I would hide columns or rows or sheets with one click, and with another button I would like to unhide them. But when I hide one it should be Veryhidden, so that other users cant reveal...

I sheet 9 very hidden. How can i adjust code so it will run properly. Thanks as always Sub unhide_9() ' ' unhide_9 Macro ' With Worksheets("Sheet9") .Visible = xlSheetVisible .Select Application.Wait Now + #12:00:12 AM# Worksheets("BURN").Select...

Hello I have several workbooks that have the background info and lists in veryhidden sheets. To my dismay, Excel 2010 shows these sheet names under permissions on the backstage view. Is there anyway to prevent these sheets from showing up in the Permissions list?

I hope someone can help. I have got two sheets, one with a reasonably large table of data of information held about individuals and a second sheet which is to be used by the end user. The end user will enter their name, date of birth and their unique reference number and based on the...