hi dears
i have a table in excel that column A to H for each row must fill daily by various Personnel
now i need to write a VBA code that if rows of column A filled, personnel could not Save the file and show a message box for example " you must fill cells to column H" till other rows to H fill
i need to code for all worksheet and for rows that add daily.
tanQ
Place this macro in the code module for ThisWorkbook. Do the following: Hold down the ALT key and press the F11 key. This will open the Visual Basic Editor. In the left hand pane, double click on "ThisWorkbook". Copy/paste the macro into the empty window that opens up. Close the window to return to your sheet.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Mumps1,
tanQ so much
if i want to run it for one sheet only in my file, what could i do?
Last edited by jeffreybrown; 06-28-2019 at 12:49 PM. Reason: Please do not use full quotes.
What is the name of the one sheet?
the name is THKOriginally Posted by Mumps1
Try:
Please Login or Register to view this content.
[QUOTE=Mumps1;5145330]Try:
[/QUOTEPlease Login or Register to view this content.
it dose not work
How does it not work? Are you getting and error message and if so, what is the message and which line of code is highlighted when you click "Debug"? It would be easier to test the macro if you could attach a copy of your file.
there is no error but i could save the file before fill cell B to H
i can't attach the file here but because attachment is disable for me but can email it
To attach a file, click on the "Go Advanced" button. Scroll down a bit and click "Manage Attachments".
file has been attached
You have the macro in the wrong place. You have it in the code module for the worksheet. It should be in the code module for ThisWorkbook. Please follow the instructions I described in Post #2.
Hi again
In one worksheet i have a table with 3 column ABC column A is text that fill manualy B is number fill with vlookup and C is percentage of column B so beacuse of some row column B is zero i need to export a new table in column E to G that only show the row of previous table that column B is greater than zero to define a series by offset and count to draw a pie chart
So i need a VBA to copy and paste rows that have value in column B greater than zero in column E To G
Since this is an entirely different question, according to Forum rules, you should start a new tread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks