I have written a program using excel but there are 3 problems I cant solve that I need some assistance with.
1. I need to sort 2 tables using a macro but I need the macro to run once that particular sheet is opened (via hyperlink). The macro looks something like:
[url removed, login to view] ToRight:=8
Range(Selection, [url removed, login to view](xlDown)).Select
[url removed, login to view] Key1:=Range("D13"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
(for one table)
2. I want to customise the menu bar so that when the workbook is opened on another computer, only my menus are seen.
3. last of all, I need to protect the workbook so that no one can access the hidden pages or see the formulas Ive used within the spreedsheets - the standard paswords from excel are far to easy to crack.
I appreciate any assistance available.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
Windows XP - the program is written in excel 2000