Hi Everyone, Please help in achieving my task, I m very new to VBA macros, any how with the help of internet, I have done some work in this workbook, actually I have prepared this excel for stock and inventory management as per our requirement. In this workbook user can do following task:-
1. first select entry type, either purchase or stock out from dropdown list
2. do entries and press on purchase or stock out shape. If press purchase then automatically data will go on purchase sheet and save it and return back to home sheet for new entry and so on for same as stock out also.
3. macro should automatically save data after each entry
4. user can navigate in every sheet, but all sheets should be password protected to avoid any manipulation.
5. and if any cell in Home sheet is blank as per purchase or stock out criteria then macro should not run and throw message for either purchase or stock out.
Each sheets password is 123 and VBA project password is 1236.
Any help is highly appreciated. Thanks a lot!
1. first select entry type, either purchase or stock out from dropdown list
2. do entries and press on purchase or stock out shape. If press purchase then automatically data will go on purchase sheet and save it and return back to home sheet for new entry and so on for same as stock out also.
3. macro should automatically save data after each entry
4. user can navigate in every sheet, but all sheets should be password protected to avoid any manipulation.
5. and if any cell in Home sheet is blank as per purchase or stock out criteria then macro should not run and throw message for either purchase or stock out.
Each sheets password is 123 and VBA project password is 1236.
Any help is highly appreciated. Thanks a lot!