Hi,
I am trying to put our Commission Spreadsheet Calculator online onto out website. When I follow the instuctions in EXCEL for saving a spreadsheet as a Web Page (selected cells to show & selected same as print range) > Select Entire Workbook > [Publish] > Select Print Area > Check Box for Add interactivity with: Spreadsheet functionality > Check Box for Open published web page in browser > [Publish]. At this point my Explorer Browser displays the spreadsheet and it has functionality. Good so far.
1st Problem - The online spreadsheet displays the EXCEL row and column tabs and I need it without looking like an EXCEL Spreadsheet - just the selected calculator cells. Can I do this?
2nd Problem - Any cell in this online spreadsheet can be edited now but I really need to restrict any editing of the spreadsheet to just one cell to fill in the sale amount to be used for its calculation. The Protect Worksheet does not work when saving as a Web Page. Can I do this?
I would appreciate any help that you can give me.
Thanks
Daryl Burns
626-303-0767
Bookmarks