Hide macro's

[Guest]

I've made an Excel-sheet (Office 2000) that calculates Sudoku solutions.
I's there a way to hide the macro's in this sheet to prevent the users
to see how it's done? I don't think it can be made with the lock function
since the users are supposed to write and delete numbers in the sheet.

So, is there a way to hide just the macro's?

 

[Paul B]

Clippan, protect your VBA project,

To protect the VBA project, from your workbook right-click the workbook's
icon and pick View Code. This icon is at the top-left of the spreadsheet
this will open the VBA editor, in Project Explorer right click on your
workbook name, if you don't see it press CTRL + r to open the Project
Explorer then select VBA project properties, protection, check lock project
for viewing and set a password. Press Alt and Q to close this window and go
back to your workbook and save and close the file. Be aware that this
password can be broken by third party software
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Many thank's!
My knowledge about Excel-programmimg is very limited
and my macro's are very simple and thus very long.
Anyway, I think it's fun to have done something like that.
I had no idea how to do this code-protecting, and frankly
I don't really know what that meant . But it worked!

//Clippan

Clippan, protect your VBA project,

To protect the VBA project, from your workbook right-click the workbook's
icon and pick View Code. This icon is at the top-left of the spreadsheet
this will open the VBA editor, in Project Explorer right click on your
workbook name, if you don't see it press CTRL + r to open the Project
Explorer then select VBA project properties, protection, check lock project
for viewing and set a password. Press Alt and Q to close this window and go
back to your workbook and save and close the file. Be aware that this
password can be broken by third party software
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003