pops

Hi all - I have a macro that will open a bunch of files, update the links, and save them. Occasionally a link can't be updated and an alert pops up. Is there a way in the macro to answer that pop-up? I want to code "Continue" to the Alert. Any help would be most appreciated. Amy

I want to duplicate a worksheeet (Tab) within a shared workbook? When I try it the conventional way by right clicking on the tab a message pops up that says it's not allowed in a shared workbook. Thanks.

Hello everyone, https://imgur.com/a/0r4JGFn This is a sample spreadsheet but.. Is it possible for column Snowball to display a 1 when it meets the criteria and 0 when it doesn't? Likewise, can Douglas display a 1 when it does and a 0 when it doesn't...

so when ever i type / it show up like this , i think it supposed to be alt function but in my excel when ever i type "/" it pops up help me

Private Sub Worksheet_Deactivate() If Range("B1").Value > 5 Then MsgBox "ERROR: There are estimated hours and/or dollars agains a ""Parent"" WBS level." End Sub If this results in True and the message box pops up, can I make it so the code brings the user back to the sheet they...

I have been successfully using a macro that I learned here a few years ago but it stopped working. It doesn't show up in Macros anymore and I can't open the editor by using Alt+F11. When I try, it says out of memory. Now, this is affecting every Excel workbook I am in--which do not have their...

I have a large workbook that I use for my business. On each page I need to enter dates over and over again. Is there a way to format a cell so that one of those little calendars pops up every time I go to that particular cell? I'd rather click on a date on the calendar than have to input dates...