May 24 2022 07:20 AM
I have two questions I need to get answered:
1. When I open my Excel Database I get the following Message: "This workbook contains links to one or more external sources that could be unsafe." I get this because I have cells that I copied from one worksheet to another.
WHAT I WOULD LIKE TO KNOW: Is there a way perhaps with VBA code that I can get this message to not show up every time I open the database. If the answer is yes You need to know I am not that good at writing code so I will need that sent to me in detail. If there is no way to get that message to disappear that will be ok I can live with that.
2. I need to auto fill when ever the database is open the following:
The current year (for example: 2022)
The next year (for example: 2023)
and one cell that shows the current month and year. (for example: May, 2022)
I have tried looking on line and none of the code or formulas that I have looked at work.
Any help you can give will be greatly appreciated.
Thanks
Bill
May 24 2022 07:31 AM
2) Select the cell in which you want the current year.
Enter the formula =YEAR(TODAY())
Select the cell in which you want next year.
Enter the formula =YEAR(TODAY())+1
Select the cell in which you want the current month and year.
Enter the formula =TEXT(TODAY(),"mmmm, yyyy")
May 24 2022 09:21 AM
May 24 2022 11:02 AM
Do you want to keep the links, but without the warning, or would you like to get rid of the links?
May 24 2022 01:58 PM
May 24 2022 03:09 PM
Select File > Info.
On the right hand side, you should see 'Edit Links to Files'.
Click on this link.
In the 'Edit Links' dialog, click 'Startup Prompt...'
Choose the second or third option, according to your preference.
Click OK.
May 24 2022 04:16 PM
May 25 2022 12:40 AM
I'm afraid I cannot help you without seeing (a copy of) the workbook. Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
May 25 2022 06:15 AM
May 26 2022 01:30 PM
I am doing the copy paste (using: Paste Link (N). After I complete the paste I protect the sheet. Under the protection options I have none of the boxes checked. I don't know if I am suppose to have something checked.
When I go back in and reopen the worksheet I get two warnings (I have attached them for your review). I would like to know how I can get rid of these two warnings like you helped me with earlier. I tried to look in the "Edit Links to files" (I have the last one checked "don't show the warning but do the update".
Is there anything I can do to get rid of the warning signs. Once I click ok the link still works the way it is supposed to.
May 26 2022 02:33 PM
Select the link to the file that cannot be found and click Break Link.
May 26 2022 06:16 PM
May 26 2022 11:11 PM
Select File > Info.
On the right hand side, click Edit Links to Files.
You should see the link or links here, and the Break Link button.
May 27 2022 10:04 AM
May 27 2022 10:10 AM
Without seeing (a copy of) the workbook, I don't know what to do about the Break Link problem.
But see what happens if you select "Don't display the alert and don't update automatic links"
May 27 2022 10:20 AM
I have attached the file for your review.
May 27 2022 11:47 AM
I was able to get into the "Break link" but when I did break the link the copy past disappeared.
I did find on the left side of the Info page in the section "Security Information" and trust center settings there could be something to remove the warning's I just couldn't figure out which section it would be in. If you could look in there and find the correct page and what I need to check that should resolve the problem.
Thanks
May 27 2022 11:53 AM
The reason that you can't break the links is that the worksheet is protected. Do you know the password to unprotect the sheet? If so, please unprotect it, then try to break the links again.
May 27 2022 12:12 PM
Did you try setting "Don't display the alert and don't update automatic links"?