Hide Row Column Headers

**Greg1234** · 09-01-2007, 12:18 AM

I would like to hide the Row and Column Headers when a worksheet is activated.
I have generated code by recording a macro in Excel, but where do I place it to make it automatically activate?

Thanks
Greg

**Paul** · 09-01-2007, 12:35 AM

Hi Greg,

You would place the necessary code into the ThisWorkbook code page, in the Workbook_Open event.

(In the VBA Project window, beneath your workbook's grouping you should see 'ThisWorkbook'. Simply double-click on that, then select 'Workbook' from the General drop-down list in the right-hand window, and select Open in the second drop-down.)

**Greg1234** · 09-01-2007, 02:31 AM

Paul,

Thank for your reply.
I tried it but it will not let me use 'Activesheet' in the code.
It will not even let me run the macro I recorded. It tells me
it is expecting a Function or variable.

Greg

**Kayote** · 09-01-2007, 05:05 AM

Greg,

You would place the code inside the 'Thisworkbook' node.

Choose Workbook/SheetActivate event and insert your code.

e.g:

Please Login or Register  to view this content.

Kind Regards,

**Greg1234** · 09-07-2007, 02:32 AM

Kayote,
I couldn't get this to run either.
Your Workbook_Open code appears to have no procedure in it.
Am I missing something here?
Greg

**royUK** · 09-07-2007, 06:56 AM

You can do this manually,Tools menu, Options then the View Tab. You wills see Row & Column headers. If you really want VBA then use the Worksheet_Activate event

Please Login or Register  to view this content.

**Greg1234** · 10-09-2007, 01:55 AM

Thanks for the help.

I'm going with the manual method.

Hide Row Column Headers

LinkBack

Thread Tools

Rate This Thread

Display

Hide Row Column Headers

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions