Cable Forum

Cable Forum (https://www.cableforum.uk/board/index.php)
-   General IT Discussion (https://www.cableforum.uk/board/forumdisplay.php?f=19)
-   -   excel 2002 question ( dates ) (https://www.cableforum.uk/board/showthread.php?t=30326)

Raistlin 16-06-2005 22:45

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 :)

paulyoung666 17-06-2005 17:16

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

Raistlin 17-06-2005 17:23

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?
__________________

?

LemonyBrainAid 17-06-2005 17:34

Re: excel 2002 question ( dates )
 
Nice code gazzae, couldn't of written it better myself.

Gotta love the Visual Basic macro editor inside Excel...

gazzae 17-06-2005 17:34

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

Raistlin 17-06-2005 17:34

Re: excel 2002 question ( dates )
 
Nah, it works with the sheet protected, I just tried it on the example Paul sent me :)

gazzae 17-06-2005 17:39

Re: excel 2002 question ( dates )
 
Quote:

Originally Posted by Raistlin
Nah, it works with the sheet protected, I just tried it on the example Paul sent me :)

Doesn't work for me if I have the sheet protected.
__________________

Quote:

Originally Posted by LemonyBrainAid
Nice code gazzae, couldn't of written it better myself.

Gotta love the Visual Basic macro editor inside Excel...

Why thank you. :blush:

Raistlin 17-06-2005 17:52

Re: excel 2002 question ( dates )
 
Quote:

Originally Posted by gazzae
Doesn't work for me if I have the sheet protected.

Doesn't work for Paul either, but does if he protects the whole workbook.

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.....

paulyoung666 17-06-2005 18:11

Re: excel 2002 question ( dates )
 
its not really critical ,i would like to do it if possible though :)

Raistlin 17-06-2005 18:24

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?

paulyoung666 17-06-2005 22:47

Re: excel 2002 question ( dates )
 
Quote:

Originally Posted by Raistlin
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?


not yet , but i will do , thanks for the continuing help :)

Raistlin 17-06-2005 22:50

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.

paulyoung666 17-06-2005 22:54

Re: excel 2002 question ( dates )
 
Quote:

Originally Posted by Raistlin
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.


are you offering :nworthy: :D :D :D :D

Raistlin 17-06-2005 22:55

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