prompt

Hi, In one of my workbooks, if I try to save it after changes, I am not prompted. The workbook just closes. There are no macros in the workbook. How can I turn the prompt back on? I close the workbook and it just closes which is annoying. Thanks

Hello, I would like Excel to prompt the user with this question, "Are You Sure" when selecting the 'Clear All' button on my form. Here's what my code looks like now: Macros Name = ClearYNH Sub ClearYNH() ' ' ClearYNH Macro ' '...

Hello I have a worksheet filled with attorney names on top cell and their telephones and faxes on the second cell (beneath their names), I wish to convert all of these into named ranges, so I need a macro to name each cases ( loop through all on the sheet) Thanks, regards

I'm using this to prompt the user to save a a word document in their chosen location; With Application.Dialogs(wdDialogFileSaveAs).Name = "Welfare Document - RM " & TextRM.Value .Format = wdFormatXMLDocument .Show End With If they do go on to save I need the userform to be unloaded, but the...

To save time, lets just assume the Microsoft Trust Prompt after opening a hyperlink will open regardless of trust center settings. I tried automating the prompt with something simple like: Application.Wait (Now + TimeValue("00:00:05")) Application.SendKeys ("{LEFT}")...

Follow up from a (very) old post: https://www.mrexcel.com/forum/excel-questions/322118-disable-password-prompt-upon-opening-spreadsheet.html I wondered if someone could advise if its possible to de-activate the password prompt. I have a macro in place to link all the sheets to my master sheet...

Hi I would like to use a pop prompt to disable a particular sub within a module from running? The prompt would appear on opening of the workbook. If the user clicks "No" this would disable the sub from running. Is this possible to achieve? Many thanks

Hi I have two spreadsheets where I link information from one to the other. Each time I open I see the prompt to ''Update Links'' which I click and all is updated. Now I am starting not to see this prompt and the information is not being updated When I do see the prompt it also now advises that...

I have a VBA code to save as my file in other location but I need an improvement to save as my file without dialog prompt ActiveWorkbook.SaveAs Filename:="C:\Users\alex-cccp\Desktop" & ActiveWorkbook.Name, FileFormat:= _ xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _...

Hi, I hope this is an easy one someone could help with - how do you put a password prompt in a macro so that it brings up a message box asking the user to enter a password before the macro runs successfully? Also is it possible to password restrict all macros so that no one came go in and alter...

I am having a difficult time figuring out how to have a yes/no messagebox selection open another yes/no messagebox. Is this not possible and I need to use a userform?

Hi I have the following path in vba which at the moment is static: "C:\Completed Scorecards\May" Rather than May being fixed, is it possible to prompt the user to key this in using an InputBox so the user can specify June, July etc? thank you

I've looked around quite a bit and I can't seem to find any way to display a ≥ sign in the text (prompt) of an inputbox. ChrW(&H2265) doesn't work. It just gives me an = sign and the ansi/ascii character set doesn't include a ≥ sign so I can't just use chr() to get one either. I really would...

Hello Team, I'm opening excel file from command prompt using below command: start excel.exe "D:\Temp\MyFile.xls" /e/%SR%-%CR% SR and CR are two arguments being passed. When Excel files open, I'm checking if it is being opened by command prompt or by user manually. This helps me decide if to...

whenever I close a workbook, even though no changes have been made, a message box prompt to save or not almost always appear. I want the workbook to prompt only when there are changes made - and close right away when there are not (no prompt nor message box).. thank you

My code so far is: Option Explicit Private Sub Worksheet_Calculate() Dim Rng1 As Range Dim Value As Double Dim Prompt As String Dim Title As String 'Put the range you want to test here Set Rng1 = Range("T14") 'Put the target value here...

I need some help with a project at work. I need to translate A BUNCH (about 10,000 lines) of old VB6 code into something that will run on modern computers, and I think excel's VBA is the best choice (for IT/security reasons, they won't let me go around installing any sort of VB6 runtimes on our...

Hello you amazingly helpful Excel wizards! I have a csv file that I'm fixing up using VBA. I'm getting errors about running out of memory and have read that saving the file can help resolve that. I'd like to prompt the user to save the file immediately after the macro is ran but can't seem to...

Hi I have this code; Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim wsSheet As Worksheet For Each wsSheet In Worksheets wsSheet.Visible = xlSheetVisible If wsSheet.Name <> "Cover Page" Then wsSheet.Visible = xlSheetVeryHidden End If Next...

I want to open an existing file and prompt the user to use the mouse to indicate where previously selected material should be posted. My code is Dim rRange as Range Dime OpenFileUpdate as String, OpenFile as String, CurWks as String Windows("CashWorksheet.xlsm").Activate...