Convert a Macro Enable workbook in to a web page

**Saji P** · 11-30-2013, 11:16 AM

Hi everyone,

I'm new to here. have a problem related to save a macro enabled workbook which can open as a web page. I have two excel sheets. First one contain charts and the other one contain a drop down box and a simple macro to hide unhide Rows a table contains data.(table also in the same sheet). i need them to work as in excel when i open them as a web page.

I have to give an idea about a dash board which is going to developed in my office. That will be done by some experts. i just want to give them an idea about what we need. Please help me...

**6StringJazzer** · 11-30-2013, 06:47 PM

This cannot be done by simply saving an Excel file in some special format. Excel will save a file in HTML format, but hiding rows based on user input goes beyond what HTML does. It requires JavaScript or other browser-side scripting at a minimum, and possibly back-end coding. You might be better off using a web-based spreadsheet, like Google Docs. Google Docs can import your Excel file and you might get similar behavior.

**Saji P** · 12-01-2013, 01:27 AM

Thanx for your reply. i tried to upload the file to Google Docs. But it is not a supported file format to upload. I made up my mind to make the project to open in Excel and applied few simple macros to hide/ unhide rows and protected the worksheet from editing.