User opens a copy of a template and clicks a button on the Master sheet (in
their copy), which creates a new sheet and adds 3 buttons from the Forms
toolbar. The new buttons are displayed over the range("H5:J10") in the new
sheet. All the user's work is done in cols("A:F"), and such are the
columnwidths, I think that cols "H:J" will always be visible in their
working view.

In my limited testing, this was fine from a user's point of
view..........but if they are working with a lot of data (ie a lot of rows)
then they have to scroll up the sheet to click those buttons.

Can I 'freeze' them somehow, please?

Regards.

No, but you could make a floating toolbar.

--
Regards,
Tom Ogilvy


"Stuart" wrote in message
...
User opens a copy of a template and clicks a button on the Master sheet
(in
their copy), which creates a new sheet and adds 3 buttons from the Forms
toolbar. The new buttons are displayed over the range("H5:J10") in the new
sheet. All the user's work is done in cols("A:F"), and such are the
columnwidths, I think that cols "H:J" will always be visible in their
working view.

In my limited testing, this was fine from a user's point of
view..........but if they are working with a lot of data (ie a lot of
rows)
then they have to scroll up the sheet to click those buttons.

Can I 'freeze' them somehow, please?

Regards.

Thanks.
Heard the term ...will investigate.

Regards.

"Tom Ogilvy" wrote in message
...
No, but you could make a floating toolbar.

--
Regards,
Tom Ogilvy


"Stuart" wrote in message
...
User opens a copy of a template and clicks a button on the Master sheet
(in
their copy), which creates a new sheet and adds 3 buttons from the Forms
toolbar. The new buttons are displayed over the range("H5:J10") in the
new
sheet. All the user's work is done in cols("A:F"), and such are the
columnwidths, I think that cols "H:J" will always be visible in their
working view.

In my limited testing, this was fine from a user's point of
view..........but if they are working with a lot of data (ie a lot of
rows)
then they have to scroll up the sheet to click those buttons.

Can I 'freeze' them somehow, please?

Regards.