Interactive Web Pages

Resolved · Low Priority · Version 2003

Wed 10 Dec 2008, 16:38 Delegate Tania said...

Tania has attended:
Word Advanced course
Excel Advanced course
Project Management - Framework & Processes course
Access Intermediate course

Interactive Web Pages

How secure are the pages? Are they intranet or internet?

Thu 11 Dec 2008, 10:00 Trainer Pete said...

RE: Interactive Web Pages

Hi Tania,
Thank you for your question;
In answer: Interactive web pages are able to be used both on the internet or an intranet as they are just a copy of the worksheet using HTML. You can add security to the pages just as you can to a worksheet but you cannot add a password... it just wont work if you do.
However just the security is sufficient as anyone wishing to make changes to the areas not protected would need to have access to the actual source worksheet itself.
I hope that helps.. Pete

Wed 17 Dec 2008: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips