warning

Hello! I had a macro in Outlook that was working perfectly well in suppressing the "No Subject" warning. Due to inferior hardware here at work the only way I can be sure my work is truly saved is to email it to my home email. I do this 50-60 times a day when I am on a project. For some reason...

My workbook can have hundreds of worksheets. I have a macro that wil loop thru them , activate each sheet, perform a funtion and then move to the next. At times i can not always tell if it is runnng or hung up. How can i display a warning like "active Work sheet is (Sheet name)" and have it...

I am working on a worksheet called "Index" and I want to take C8:H8 and copy and paste the content onto worksheet called "Warning." I want to go to the sheet called "Warning" and find the next empty row and paste. For some reason I am struggling to figure out how to find he next empty row...

It's been a while I have been getting a warning message that pops up on excel when I do Ctrl +c or right click + copy The message says: "There's a problem with the clipboard, but you can still paste your content within this workbook" This issue doesn't happen every time I do Ctrl + c I have...

Hi, The code in use is shown below. Please can you explain why or what this part refers or does warning = MsgBox(Range("A6").Value I press the button,i am asked the question,the range in question that will be changed to 0 is C1:F17 so im lost as to why A6 is even there..... Sub zero()' '...

Hello, I have a few pop up questions that appear prior to running the main macro. They ask questions such as did you enter in the correct email addresses and so on. The issue is I've been testing my completed macro and I tried clicking "No" on one of them and the macro continued which destroyed...

Hello, I have a workbook that has many rows of data. I wrote a macro that filters on column B, then the macro inserts a formula into column C to copy over the first 4 characters. I am using this line of code to bring the characters over filling in to the last row. <code> 'Below Inserts a...

Hello, I have a file I update it every week and send it to my managers and colleagues.Recently I get a message of protected view, andI have to choose "Enable Editing" to do my data entry. It always happens when I get a “save as” or renamemy file. My problem is with inserted comments. I hide my...

Hi All, Please, can anyone help me build a fixture creator for a league that I'm participating? Here is the setup :warning: 14 teams play each other.(There would be 91 games in total, correct me if I'm wrong) :warning: For each week there should be two games for one team. :warning: All the...

Hi All, Please, can anyone help me build a fixture creator for a league that I'm participating? Here is the setup :warning: 14 teams play each other.(There would be 91 games in total, correct me if I'm wrong) :warning: Each week there should be two games for one team. :warning: All the...

Dear Team, I have an excel sheet which is filled by line managers. Very often i get back incomplete sheets. 1) I have drop down values enabled in Column "C". If drop down value is selected as "YES", then columns "E" to "H" are mandatory. User should not be able to save the sheet without...

I need a way to make a warning if the cell value don't add up with another number. example. 15 rolls don't add up in a box of 10. Then it should pop-up a warning and let you choose between 10, 20 or to don't do anything. Hope there is an easy way of doing it. Thanks for any reply :)

Good afternoon, I looked through multiple posts on the forum boards, but something is not working properly with my code. I was hoping some of you VB experts can help me. What I wish for it to do = look up errors in a column, highlight the erroneous cells red, and popup a msgbox once saying...

So I have spent a fair amount of time creating Lockout Tagout Procedures, And I did this using Excel. (i still don't know why anyone uses word for anything. document layout is so much easier in excel) but now my boss wants me to put a "Warning Boarder" around the edge. Like 1/2 inch diagonal...

Hi guys, I have a named table ACR_tbl, I would like to count all the times #N/A appear in the table. If the number is greater than 0 I would like to pull up a MsgBox as a warning. At the moment I am doing this (to an extent with COUNTIF(ACR_tbl,NA()) ), is there a simple way to do it via VBA?

<colgroup><col></colgroup><tbody> If click on the cell below =HYPERLINK("C:\/File%1.msg","File 1") there is warning message (there may have virus in file, as translated from Chinese Excel) How to set so that this warning message will not prompt? </tbody>

Greetings. I created macros in Excel 2003, but those macros now always trigger a security warning when I open the spreadsheet with a macro. Until recently, I could eliminate the security warning by creating my own digital certificate and then digitally signing the macro. That no longer works...

Hello People, If cell A1 is not with pre-defined parameters, I would like code for a warning to pop up and cancel execution of the macro assigned to a format control button when clicked. Any takers? Thanks in advance .....

I have a "master" excel that loops through a folder of excels, opens them, runs a variety of macros and then saves and closes them. I have always had some excels that crash the application and I finally narrowed it down to excels that have a circular reference in them. I have disabled alerts and...

All, I am a Data Reporting Analyst and I could use a little help. I am trying to return results for the following. What I am trying to find is an employee that has been with the company greater than or less than 90 days IF so how many absences in one column return the value based on the absent...