Macro

The UK's most regular instructor-led training courses.
Training information: excel+courses+in+london · Advanced.excel · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

1 post

ReplyTue 2 Feb 2010, 16:39Delegate Agnieszka said...

Agnieszka has attended:
Excel Advanced course

Macro

How to protect created button from being pressed by unauyhorised person?

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Fri 19 Mar 2010	Bloomsbury	1		£240	£245
2003	Wed 24 Mar 2010	Limehouse	7		£212	£217
2007	Fri 26 Mar 2010	Rochester (Hoo)	0	FULL
2007	Mon 29 Mar 2010	Bloomsbury	2		£235	£240
2003	Wed 31 Mar 2010	Southwark	7		£219	£224
2007	Tue 6 Apr 2010	Limehouse	5		£235	£240
Full Schedule: See all 70 Excel Advanced course dates. Bookings currently available until 22nd December 2010.

1,056 posts

ReplyWed 3 Feb 2010, 12:48Trainer Andrew said...

RE: Macro

Hi Agnieszka

Thank you very much for your question. If we add a Macro to a spreadsheet anyone with the ability to run macros (Tools > Macros > Security) will be able to run it.

It is possible to create Macros that perhaps require a password before they run - but to set this up we would need some additional VBA programming which is unfortunately outside the scope we can cover on the forum.

I hope this goes some way to answering your question.

Do let us know if you have any further questions.

Kind regards,

Andrew

Tue 9 Feb 2010: Automatically marked as resolved.

· Say It With Ribbon
· Tips to Facilitate Printing of Excel worksheets
· Want To Use Excel To Calculate Your Mortgage Repayments?
· So Can You Really Sort On Colours In Excel 2007?
· Fun Things I've Done With Excel

Please browse our web site to find out more about
excel+courses+in+london and other Microsoft training courses.

Excel tip:

Using an equal (=) sign that isn't part of a formula

Before you type the equal sign, type an apostrophe: '
Then type your equal sign: = (and anything else you want to add after your equal sign)
Press ENTER.

(the apostraphe will disappear

View all Excel hints and tips