auto lock cell when data and save

arifpunekar

New Member
Joined
May 2, 2014
Messages
32
sir I have macro enabled workbook with huge data, I want to auto lock cell when data entry and save . I want to change data authority or password with login,I have copy the vba code following but data not auto lock, and take more time for saving ,
so sir I want to auto lock cell when data entry and save and changes permission with login and save process complete in one minute.
sir so please tell me the solution as possible as early.
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,109,041
Messages
5,526,417
Members
409,701
Latest member
nitmani

This Week's Hot Topics

Top