ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   File Save Macro as Cell content (https://www.excelbanter.com/excel-programming/383520-file-save-macro-cell-content.html)

TonyD

File Save Macro as Cell content
 
I currently open a workbook that goes to cell A1 which contains a filename
with required filenaming conventions(REPORT NAME_DATE_PG#_MST#). I want the
user to be able to edit the cell if the content equals "REPORT
NAME_DATE_PG#_MST#". Once they edit the cell and finish populating the
worksheet they will close the workbook with the current content on cell A1 as
the new filename.xls(Sudbury_012907_PG1_MST003). Also once they have changed
the A1 cell content it should lock and not be able be changed again no matter
how many times they open it.


All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com