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

macro

ResolvedVersion 2003

Agnieszka has attended:
Excel Advanced course

Macro

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

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.

Excel tip:

Move to edge of data block

When data is held in a block, however large, use the Ctrl key with your cursors to move quickly to the far edge of the block. Works with all 4 direction keys.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.