Will Macro work on a hidden spread sheet

I have a big program I'm working on. One of the spreadsheets is just a feeder sheet that uses outlook calendar field names so it's really ugly. That's why I prefer to hide this sheet.

Will the macros that are exported and imported into a hidden spread sheet like this still work?

You probably mean worksheet which is hidden (macros could be included in worksheet code, but more often are located in a module, which is associated with workbook, not with worksheet).

In this case - general answer is: yes macros wil work on it.

Keep in mind that there are two levels of hiding worksheets - via the interface you can only make it hidden or visible. With VBA you can make it visible, hidden or very hidden! Check out worksheet properties in VBE (Ctrl+F11).

Best Regards,

Yes it's a Workbook with like 12 different work sheets.

On the tabs below I would like it if the ugly work sheet does not appear.

This sheet has Macro's going to and from it.

Just wondering if the macros will still work.

It doesn't have to be very hidden.

OK. There is a hatch. If you have a macro, which has been registered for this (hidden) sheet - it will probably not work. In the registered code you will have almost everywhere constructuions like

Please Login or Register  to view this content.

99,9% of such constructions could be changed into:

Please Login or Register  to view this content.

Which works on hidden worksheets.

Originally Posted by xladept

...you can't use select on a hidden sheet...

Omission on my part, quite true. If you have macros that were generated by the macro recorder then you will certainly have this type of construct and have problems.

So this Spread sheet takes 7 fields from column in the sheet in front of it in the work flow and use those values in 7 columns.

Then this whole sheet has a 1 way sync to outlook calendar.

What I'm not sure about is if that sync will be a import from outlook or a export from this sheet.

So what do you guys think? Will it work or is there something else easier here that I am missing to make this ugly sheet be hidden.

I know this sounds stupid or maybe stating the obvious but all the macros will be done before making the work sheet invisible.

I'm new to Excel so please cut me a break. Never had any classes and only owned Excel for 2 months.

Always a good idea to attach your file to get advice specific to your situation. Having your file will let us experiment with your data, formulas, and code, and possibly attach a file with a completed solution.

To post a file:

1. Under the text box where you type your reply click the Go Advanced button.
2. In the next screen look above the reply box and click the "paper clip" icon. You will get a pop-up screen.
3. In the pop-up, click Add then Select to select a file from your local drive
4. Click the Upload button to upload the file
5. Click Done to attach it.

It will be displayed as an attachment underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.

I will upload here later when I get a chance. I can't load the whole thing here as it has a non disclosure agreement on it between me and 2 other programmers as a whole so I have to figure out how later how to remove just one of the work sheets out of the work book.

Okay here it is without any macros

Originally Posted by schmidtpainting

Okay here it is without any macros

In my opinion this is backwards from what we need--in this case it would be more useful to see the code that will operate on this sheet. The issues that arise when you run code on a hidden sheet are not evident from the sheet itself, they are evident only in the code.