What's the best way to create a custom user guide for a workbook?

maravig

Board Regular
Joined
Jul 16, 2014
Messages
61
I have a workbook project nearing the end and I have to create a user guide. I've trying to locate a template/add-in or something to give me an idea of the best way to do this but I haven't found anything solid yet. Does anyone have any suggestions about how to go about this? Should I create a userform and add it to the Ribbon somewhere? Some other method perhaps?

Thanks,
Jeff
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
.
.

If you can get hold of a copy of John Walkenbach's "Excel Power Programming with VBA" paperback/ebook, it has a whole chapter (Chapter 24) on this topic. It includes:

Using cell comments for help
Using text boxes for help
Using worksheets to display help text
Displaying help in a UserForm
Displaying help in a Web Browser
Using the HTML Help System

etc.

I thoroughly recommend it!
 
Upvote 0

Forum statistics

Threads
1,203,686
Messages
6,056,737
Members
444,888
Latest member
Babi_mn

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