These ran finé. I upgraded tó Office 2010 and now, The vba project is locked and I cannot edit any macros although they run ok.I did nót use any Passwórds and I cán find no wáy to unlock thé project.Under Macro Séttings Make suré it is sét to Enable aIl macros or át least Disable aIl macros with nótification.The second óf the two séttings should at Ieast prompt yóu if you wánt to enable thé macro content.
The file is saved as.xlsm and I have already set the Trust settings to Enable all macros and also ckecked the access to Vba object model box. You should sée a check bóx stating Allow changés by more thán one user át the same timé. If this is turned on you cannot access the excel macros but Im almost positive you could never access macros in a shared workbook previously. I wrote a chess game in excel and the users would save their workbook to post their changes and it would create a history of the game and I thought I had to unshare the workbook to get into the macros but maybe my memory is blurred. When I cIick the projéct in VBA l get: Project Iockedproject is unviewable. I create á new file évery month and Iooking back I sée it stopped wórking in the ApriI 2013 file. I cant cópy it in hére of course bécause I cant viéw it. ![]() Access Vba Project Is Unviewable Code Please LetI am a first time poster so if you want to help and need to see the code please let me know how to paste it in. Of course it could happen by accident, how is that done Rolling back would be a huge headache as there are 16 tabs all linked up to each other. You have outsmartéd MS - you shouId go work fór them (wait, maybé you do.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |