Sheet for managing contracts

Hi! I need your help to make a excel sheet of managing my contracts.

Please find the attached excel sheet to understand better.I am sure it will be helpful for all of the users.


Thanks

Navneet

See attached file where I added this macro:

Please Login or Register  to view this content.

Regards,
Antonio

Thanks Antonio! It is working fine but I don't want the Macro to be run manually.Is it possible Macro should run when I save the file and at the time of opening of file.

I will enable this file at the start-up so that I switch on the computer this file will open.


Also is it possible if I don't open this excel sheet,Windows will give me message for expired contracts or excel sheet will open forcibly once to show the user about expired contracts

Waiting for your reply.

Thanks once again.


Navneet

I added this code to run macro when open and save workbook

Please Login or Register  to view this content.

To do the rest might be an idea to use vbscript using windows scheduler.

Regards,
Antonio

Thanks Sir! Its working now the way I wanted.


Thanks once again


Navneet

I need a help to open the excel file at the start up or when users logs on to conputer.


Thanks

Navneet

Hi everbody.
Am glad to be part of the forum. I am a legal professional.
Can anybody help me out and provide me a comprehensive Excel Template for Contract management, where actions can be recorded or log can be maintained. In addition a check can be put for reminder for to do actions.
regards,
Yousuf Alam, Advocate

Hey everyone.

It's my firs post, aand my English is quite poor, so please be tolerant :D

I am also in need of a contracts management sheet, so, after days of failed attempts, Google brought me here.
I've attached an xls, hoping that first of all you can understand my needs, and of course, that you can help me
with my problem.

Anyway, thanks everyone in advance

Contracts Progress.xls

Ok, I created the thread as requested.

Thx.