Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 111
  • Last Modified:

Add a button on MS-excel sheet when clicked opens a dialog box with instructions on the sheet

Hi Experts:

I need help in MS-excel.  

I want to add a button on the excel sheets.  When the button is clicked a dialog box opens with instructions.  I want to add instructions on the dialog box on how to use the excel sheet.  I want to add the button on every sheet with different set of instructions.

Please help on how to do this.  Is there any better way of doing this?

Thanks,
0
imranasif17
Asked:
imranasif17
  • 2
2 Solutions
 
Haris DjulicCommented:
Hello,

please find attached possible solution... In the sheet params for every sheet you define which text to appear and then when clicke on the respected sheet the dialog box will display entered text..

Hope it helps
Help.xlsm
0
 
imranasif17Author Commented:
Hi Haris:

Is it required to save the file as .xlsm?

Thanks,
0
 
Haris DjulicCommented:
Since it has the VBA code it must be either .xlsm or .xlsb..
0
 
Rob HensonIT & Database AssistantCommented:
IF you don't want VBA, you could set a cell as a hyperlink and link to a section of text on each sheet way over to the right or a separate sheet and then a hyperlink with this to link back to the working area of the sheet.

Thanks
Rob H
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now