I want to put some macros at the top of a worksheet which will hide/unhide
columns depending on the information I want to see. But I want the macros to
be always visible and not affected by the macro actions. Is there a way I
could exclude the top rows from the macro actions?
Thanks

hi
not sure exactly what you mean but if you mean hide part of a column...
no can do. a column is either hidden or visible. you can not hide part of a
column.

Regards
FSt1

"Oceangate" wrote:

I want to put some macros at the top of a worksheet which will hide/unhide
columns depending on the information I want to see. But I want the macros to
be always visible and not affected by the macro actions. Is there a way I
could exclude the top rows from the macro actions?
Thanks

Maybe you could give the users (you?) a different way to run the macros:

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

In xl2007, those toolbars and menu modifications will show up under the addins.




Oceangate wrote:

I want to put some macros at the top of a worksheet which will hide/unhide
columns depending on the information I want to see. But I want the macros to
be always visible and not affected by the macro actions. Is there a way I
could exclude the top rows from the macro actions?
Thanks

--

Dave Peterson

I'll check out those tips Dave, Thanks....

"Dave Peterson" wrote:

Maybe you could give the users (you?) a different way to run the macros:

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

In xl2007, those toolbars and menu modifications will show up under the addins.




Oceangate wrote:

I want to put some macros at the top of a worksheet which will hide/unhide
columns depending on the information I want to see. But I want the macros to
be always visible and not affected by the macro actions. Is there a way I
could exclude the top rows from the macro actions?
Thanks

--

Dave Peterson

Hi,

why not just add buttons to one of the toolbar, the toolbars are visible
when you hide columns. And in 2007 you could add them to the QAT toolbar,
which would be a lot easier than customizing the ribbon.

In 2003:
1. Right click any toolbar and choose Customizer (the bottom choice)
2. Select the Commands tab
3. Select the Macros Category
4. Drag smiley face to one of the toolbars (keep the dialog box open)
5. Right click the new button and choose Assign Macro
6. Select your macro and click OK.
7. You can change the picture with the right mouse clicking the button and
choosing Change button image or Edit button image. You can change to
toolbutton tip by changing the Name (right mouse click again)

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Oceangate" wrote:

I want to put some macros at the top of a worksheet which will hide/unhide
columns depending on the information I want to see. But I want the macros to
be always visible and not affected by the macro actions. Is there a way I
could exclude the top rows from the macro actions?
Thanks

Thanks Shane.
I'll give it a try...

"Shane Devenshire" wrote:

Hi,

why not just add buttons to one of the toolbar, the toolbars are visible
when you hide columns. And in 2007 you could add them to the QAT toolbar,
which would be a lot easier than customizing the ribbon.

In 2003:
1. Right click any toolbar and choose Customizer (the bottom choice)
2. Select the Commands tab
3. Select the Macros Category
4. Drag smiley face to one of the toolbars (keep the dialog box open)
5. Right click the new button and choose Assign Macro
6. Select your macro and click OK.
7. You can change the picture with the right mouse clicking the button and
choosing Change button image or Edit button image. You can change to
toolbutton tip by changing the Name (right mouse click again)

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Oceangate" wrote:

I want to put some macros at the top of a worksheet which will hide/unhide
columns depending on the information I want to see. But I want the macros to
be always visible and not affected by the macro actions. Is there a way I
could exclude the top rows from the macro actions?
Thanks

When I tried to drag the smiley face to the the toolbar, nothing was copied
over. When I click on it, a + appears beside the pointer but once I try to
move it, it changes into an x which seems to suggest it's not allowed. Is
there something else I need to do to allow the transfer?
Thanks....

"Oceangate" wrote:

Thanks Shane.
I'll give it a try...

"Shane Devenshire" wrote:

Hi,

why not just add buttons to one of the toolbar, the toolbars are visible
when you hide columns. And in 2007 you could add them to the QAT toolbar,
which would be a lot easier than customizing the ribbon.

In 2003:
1. Right click any toolbar and choose Customizer (the bottom choice)
2. Select the Commands tab
3. Select the Macros Category
4. Drag smiley face to one of the toolbars (keep the dialog box open)
5. Right click the new button and choose Assign Macro
6. Select your macro and click OK.
7. You can change the picture with the right mouse clicking the button and
choosing Change button image or Edit button image. You can change to
toolbutton tip by changing the Name (right mouse click again)

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Oceangate" wrote:

I want to put some macros at the top of a worksheet which will hide/unhide
columns depending on the information I want to see. But I want the macros to
be always visible and not affected by the macro actions. Is there a way I
could exclude the top rows from the macro actions?
Thanks

You sure you left-clicked on smiley and dragged him up to a Toolbar?

He cannot be dragged or dropped anywhere else but onto a Toolbar.

When you get to the Toolbar the x will turn back into a + sign


Gord Dibben MS Excel MVP

On Mon, 24 Nov 2008 16:59:01 -0800, Oceangate
wrote:

When I tried to drag the smiley face to the the toolbar, nothing was copied
over. When I click on it, a + appears beside the pointer but once I try to
move it, it changes into an x which seems to suggest it's not allowed. Is
there something else I need to do to allow the transfer?
Thanks....

"Oceangate" wrote:

Thanks Shane.
I'll give it a try...

"Shane Devenshire" wrote:

Hi,

why not just add buttons to one of the toolbar, the toolbars are visible
when you hide columns. And in 2007 you could add them to the QAT toolbar,
which would be a lot easier than customizing the ribbon.

In 2003:
1. Right click any toolbar and choose Customizer (the bottom choice)
2. Select the Commands tab
3. Select the Macros Category
4. Drag smiley face to one of the toolbars (keep the dialog box open)
5. Right click the new button and choose Assign Macro
6. Select your macro and click OK.
7. You can change the picture with the right mouse clicking the button and
choosing Change button image or Edit button image. You can change to
toolbutton tip by changing the Name (right mouse click again)

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Oceangate" wrote:

I want to put some macros at the top of a worksheet which will hide/unhide
columns depending on the information I want to see. But I want the macros to
be always visible and not affected by the macro actions. Is there a way I
could exclude the top rows from the macro actions?
Thanks

That worked, thanks.....

"Gord Dibben" wrote:

You sure you left-clicked on smiley and dragged him up to a Toolbar?

He cannot be dragged or dropped anywhere else but onto a Toolbar.

When you get to the Toolbar the x will turn back into a + sign


Gord Dibben MS Excel MVP

On Mon, 24 Nov 2008 16:59:01 -0800, Oceangate
wrote:

When I tried to drag the smiley face to the the toolbar, nothing was copied
over. When I click on it, a + appears beside the pointer but once I try to
move it, it changes into an x which seems to suggest it's not allowed. Is
there something else I need to do to allow the transfer?
Thanks....

"Oceangate" wrote:

Thanks Shane.
I'll give it a try...

"Shane Devenshire" wrote:

Hi,

why not just add buttons to one of the toolbar, the toolbars are visible
when you hide columns. And in 2007 you could add them to the QAT toolbar,
which would be a lot easier than customizing the ribbon.

In 2003:
1. Right click any toolbar and choose Customizer (the bottom choice)
2. Select the Commands tab
3. Select the Macros Category
4. Drag smiley face to one of the toolbars (keep the dialog box open)
5. Right click the new button and choose Assign Macro
6. Select your macro and click OK.
7. You can change the picture with the right mouse clicking the button and
choosing Change button image or Edit button image. You can change to
toolbutton tip by changing the Name (right mouse click again)

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Oceangate" wrote:

I want to put some macros at the top of a worksheet which will hide/unhide
columns depending on the information I want to see. But I want the macros to
be always visible and not affected by the macro actions. Is there a way I
could exclude the top rows from the macro actions?
Thanks