web pages

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Web pages

Web pages

resolvedResolved · Low Priority · Version 2003

Anand has attended:
Excel Advanced course

Web pages

Is it possible to protect a worksheet before saving it as a webpage so that information cannot be deleted, but still allowing some to use auto-filter on the webpage?

RE: Web pages

Hi Anand,

Thank you for your question.

As far as I am concerned you cannot save a protected worksheet or a protected workbook as a webpage.

The data is only copied so if you delete it you can just close the web page and re-open it. The main use of the webpage is to enable the interactivity.

If I find a way around this I will email you again.

I hope this answers your question.

Regards

Simon

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Some examples of CTRL key shortcuts in Excel 2010

Did you know that the old CTRL key shortcuts haven't changed from previous versions of Excel to the 2010 version?

They remain exactly the same:

Ctrl+B for bold
Ctrl+I for italics
Ctrl+P to Print
Ctrl+S to Save

View all Excel hints and tips


Server loaded in 0.09 secs.