xlsheetveryhidden

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

In my workbook, I have several sheets which contain different forms and where the data is populated through vba program. I am able to print these forms only when the sheets are made visible, if very hidden the printing is not possible. I am adding thisworkbook.sheets("sheetname").activate...

Hi, I've got a macro that basically does the following: Opens data source files, that remain open (aprox. 8 files) Get a key from a list for filtering out data in the source files Copies result for and pastes in corresponding sheet in macro file Refreshes pivot tables and charts to export...

I have a file template that I use on a daily basis. When I open the file, it has a login procedure that it goes through. Basically, it hides all the sheets until the user authenticates; Then once the user authenticates, it makes all the sheets visible. The problem I'm running into is that I...

Hi all, I have quite a complicated (and probably pretty badly coded) spreadsheet. Occasionally I get an 'Out of memory' error when saving it... there's quite a few things going on with it and I have had a bit of a google and a look on here and I think it may be something to do with one of my...

hi the following code always worked but know fails Sub SubTeste() Dim sh As Worksheet For Each sh In Worksheets sh.Visible = xlSheetVisible Next sh Worksheets("Sheet1").Visible = xlSheetVeryHidden End Sub the idea is when a file is open every sheet is shown if macros are enable it...

i have some data in Output and Input sheets my intention to use xlsheetveryhidden for both sheets,because user not required to see both sheets but this sheet is interlinked to another sheets if this sheets are "xlsheetveryhidden" my macro is not running properly if they are visible my code...

Afternoon all. Got a slight problem I'd appreciate some help with. The form I've made relies on someone copying data from a separate location and then clicking on a button that generates and saves as a copy. Where I'm struggling is figuring out where to put the OnError code when they haven't...

Hi, This is driving me crazy! The idea... The user selects a value in a drop-down list, which triggers some sheets to be hidden-unhidden, and fills-up a cell with a message of the outcome. I want to use a single UDF to which I pass variables as needed (i.e. re-use the UDF for each sheet to...

I have a spreadsheet with significant VBA and five sheets. Only one sheet should be visible to the user. I currently have the main sheet and one other visible and three very hidden. I tried to hide the one sheet and I get an error, "Unable to set the visible property of the worksheet class." I...

Hi Guys. Trying to achieve a hidden sheets (No visible tabs) type scenario, but to allow visibility with a Button Control. So far, I have played with hiding the sheet by right clicking the tab and selecting 'Hide' I currently have a Comand button with the following Code: Private Sub...