From not so good memory try looking for an action called "Select text by key phrase".

If you change your data validation to what is shown below and your cells are filled with 0.00 if the data validation fails, like if someone enters a letter, when you clear the error the cell will return the value to 0.00. It will make the cell blank if they have that cell selected and hit backspace or delete but really since the cell returns the value to 0.00 there is really no reason for them to hit backspace. Of course making anything idiot proof is impossible but that might help.

Can you see these?

I don't have Excel but I did the same with Libra Office and if you remove the formula because as I see it you don't need it because you can set the format for those cells like this for two decimal places.



Then under Data Validation set it like this.



If you enter a letter you will get an error. If you delete or back space it will only delete the data as there is no formula but it will not delete the data validation.

Quote from: DigiCorn on April 19, 2024, 09:15:02 AMI have a spreadsheet I'm creating in Excel to track jobs through the shop. In it I have some formulas to math for me. Problem is, it's really easy to accidentally delete or erase the formula and screw up the cell, so is there a way (without locking or requiring a password) to protect the formula inside that cell so it doesn't lose it's format and can still be typed in to? I know how to lock it, but then you can't add any new information, and the only other trick I know requires a password every time you want to add new information. Also, without the use of a 3rd party plug-in, is there a way to make a cell have a date finder calendar?

Why would anyone need to type into the cell that has the formula? If they need to change the data they should change the values of the cell the formula is based upon.

Quote from: DigiCorn on April 10, 2024, 08:36:00 AMWhen I WFH during Covid, I used the free version of Team Viewer. I installed it on the Fiery and my workstation and of course at home. It's not perfect, but it did the trick.

Team Viewer won't work if it determines you are trying to login to a business. I tried it from home and it flagged the workplace I was trying to login to as a business and would not allow the connection. Not sure how they determine if it is a business or not though.

The old "you get what you pay for" scheme.

Also you could do it with an Acrobat preflight profile but I don't have a full blown copy of Acrobat to create one for you. You would need to create a fix up in the profile to reduce the page/content.

Not sure how many files you have to do it too but if you don't have Pitstop you could place the PDF into an InDesign 17 x 11 document and reduce it by 50% when you place it. Then export a new PDF.

So do want to shrink the content too or just change the page boxes? The Acrobat cropping too can change the page boxes. Not sure if there is an Acrobat action for that though. If you need to also reduce the content not sure you can do it with just Acrobat. Pitstop can do it though.

For Mac to PC connections I use Microsoft Remote Desktop but you would need to open the ports on your work firewall unless you already have VPS at your workplace setup to allow you to login to your work local network. Once logged into the work local network you could just connect directly to the PC IP address.

If you don't have a VPN or you can't open the correct ports from Microsoft Remote Desktop you can setup a connection via Google Chrome Remote Desktop. You would then connect t via the Google Chrome web browser to the PC that is is running Google Chrome Remote Desktop.

How to move PitStop Pro 09 or higher from one system to another?

Move your preferences and custom Preflight Profiles, Action Lists, Global Changes, ... to the new computer

This can be done easily by copying the following folders to the new system:

Windows
- C:\ProgramData\Enfocus Prefs Folder (if available)
- C:\Users\<user>\AppData\Roaming\Enfocus Prefs Folder

Mac
- HD: Library: Preferences: Enfocus Prefs Folder (if available)
- HD: Users: <Your user>: Library: Preferences: Enfocus Prefs Folder

Quote from: jv58 on March 27, 2024, 12:45:40 PMThe game changer here is pledge #3. Giving out the Affinity suite for free to schools and non-profits will create a new generation of users who only know Affinity. It may not happen in my lifetime but this could kill the dynasty that is Adobe. I hope it is successful as Adobe became greedy once they became the only game in town (sorry Quark). Time will tell.

They were always greedy. Their plan was always to destroy their competition and then stick it to the users. Worked like a charm.

UPDATE:

It makes me believe there may not even be a version 3. Canva may just swallow the products up by then.