How to handle text pages

Bernardg

New Member
Joined
Mar 5, 2011
Messages
2
I need help with a spreadsheet that I want to distribute widely. I put the introduction material and the instructions in 2 worksheets that do not look good. I would like to get rid of the menu bars.

Since I do not want problems later, I do not want to reformat the text worksheets with macros because my potential customers could get mad because I messed up their standard Excel arrangement/lay-out.

The full-screen in Excel is not complete full anyway -- it keeps the column and row bars.

The solution that I have for now is to put the introduction and the instructions on the spreadsheet worksheet in remote corners and to move around with buttons and macros. I would keep the menu bars when displaying text but I would be sure not to have "macro that did not work to restore the original format" problems.

I am also using Excel97 to be sure that the spreadsheet works for everybody.

I would appreciate some advice.
Bernardg
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Maybe put your text in a userform with a single large text box on it?

Or use PDFs?
 
Upvote 0

Forum statistics

Threads
1,214,979
Messages
6,122,561
Members
449,089
Latest member
Motoracer88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top