![]() |
Re: excel 2002 question ( dates )
Ok, jump into chat and I'll talk you through the changes :D
__________________ Actually, can you give me five minutes? __________________ I'll email you the sheet in the mean time, see if you can spot what I changed ;) __________________ Spreadsheet is on its way. See you in chat in 5 if you need to go through anything :) |
Re: excel 2002 question ( dates )
back again , raist , have you still got the file ??? , i am having a problem with protecting the sheet , when i do it wont , if you see what i mean :erm: , i get errors when i open it up , help !!!!!!!!!!!!!!!!!!!!!!!!! :D :D :D
|
Re: excel 2002 question ( dates )
Yep, still got it.
Let me try. __________________ Nope, seems to be working for me..... Want to send it to me, or want to meet me in chat and talk through it? __________________ ? |
Re: excel 2002 question ( dates )
Nice code gazzae, couldn't of written it better myself.
Gotta love the Visual Basic macro editor inside Excel... |
Re: excel 2002 question ( dates )
if you are using protection you need to unprotect before you run the code the then protect the sheet again when the code is finished.
put... Worksheets("sheet1").UnProtect password:="1234" At the start of the code and then Worksheets("sheet1").Protect password:="1234" at the end of the code |
Re: excel 2002 question ( dates )
Nah, it works with the sheet protected, I just tried it on the example Paul sent me :)
|
Re: excel 2002 question ( dates )
Quote:
__________________ Quote:
|
Re: excel 2002 question ( dates )
Quote:
Odd..... __________________ LBA has suggested that it could be because we are running two different versions of Excel. Seems that Paul has sorted it now, he simply protacted the workbook instead of protecting the sheet. __________________ Although that won't help him because it won't protect his data..... |
Re: excel 2002 question ( dates )
its not really critical ,i would like to do it if possible though :)
|
Re: excel 2002 question ( dates )
Have you tried gazzae's suggestion above about adding the code to unprotect and then reprotect as it starts up?
Not sure it will help you but it's worth a shot..... Did you try the one that I sent through to you? |
Re: excel 2002 question ( dates )
Quote:
not yet , but i will do , thanks for the continuing help :) |
Re: excel 2002 question ( dates )
NP.
I still think that once a week we should have a masterclass, presented by a member of the forum, on different technologies. Someone could do Access, Excel, PHP, SQL, Linux..... The list is endless. |
Re: excel 2002 question ( dates )
Quote:
are you offering :nworthy: :D :D :D :D |
Re: excel 2002 question ( dates )
:LOL:
Nah, most of it would be beyond me. Just thought it would be an interesting idea for a gruop Chat session or a dedicated thread. We could call it "Ask The Guru: This week <Insert Topic Here>" |
| All times are GMT. The time now is 06:23. |
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2026, vBulletin Solutions Inc.
All Posts and Content are © Cable Forum