Change cell value when workbook opens

Hi, Please help..I have tried some codes I found on various forums, but I do not seem to have any luck with them. I would like Cell value in cell V1 of sheet "View" to change to 0 when workbook is opened. Thanx a lot..

Please Login or Register  to view this content.

Hi there,

thank you for the response, however this code does not do it. I realise it should, but ..not happening. I have created a test workbook with sheet1, and tried it there..it's not doing it. I don't know if KUTOOLS has something to do with it, because everytime I open a workbook, Kutools steps in to add a navigation pane to the left of the sheet. I doubt though. Any ideas maybe?..please?

I have included the original spreadsheet, without figures...thanx a lot guys..

Hi guys,

No worries I have searched a bit and found the reason for this code not running. I have added this code to the Public module instead of the workbook Private module. The code is working just great!.. Thanx again!!