I posted this code a while back, I don't think anyone saw it. I made a slight change since then.
Anyone who as used the Datepicker add-in knows it is temperamental and doesn't work well when the code is being accessed by multiple computers.
This Calendar tool is all code, no forms needed. no ActiveX controls. Should work on all excel versions.
The appearance is totally custimizable as well.
I get a runtime error stating Programmatic access to Visual Basic Project is not trusted on this line
Please Login or Register to view this content.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
This program creates and deletes modules. Your compiler see that and errors out.
Go to Macro trust settings and enable "Trust Access to VBA project object model"
.
My system : Win 10 / 64 bits.
I receive the following error after closing the date picker (see image, line in blue). Also note that after closing it creates a new Userform and Module (for each time the macro is run).
???
DatePik.jpg
I have already enabled : "Trust Access to VBA project object model"
The calendar opens and closes 3 times for the demo. Then a form opens and you can run the calendar from the form button.
The Demo Code is in module1. Look in there and it will explain how to use it.
The reason your getting an error is that you have multiple calendar forms created, with duplicate declarations of global variables.
This happened from the code being stop with the debugging before it had a chance to delete the calendar form.
Delete both calender43210.... forms and module43210... The code will work again after that.
Before you do that try running this sub...
This is what the class uses to remove any conflicting forms/modules. It looks for " 'Delete me 989898" at the top of the module.
I have a suspicion that your Excel is not deleting these files.
Please Login or Register to view this content.
Last edited by tonyd5; 04-20-2018 at 07:23 PM.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks