How to Repair Excel File Can't find project or Library Error

For different situations some solutions to rectify the problem or to repair corrupted Excel file are always there. Like finding out the missing library or the cause of mismatch if it exists. The library is then added or alternatively the code may be rechecked to link to the appropriate library.

Step 1. Open the MS Excel file, giving an error message.

Step 2. Ensure that the sheet that has defined functions or buttons is selected.

Step 3. Press “ALT and F11 keys”, for VB Editor in a new window (as below).

Step 4. Click on Tools menu and then select References from pulled down menu, as shown

Step 5. Following dialog box will display ‘Missing object library or type’ is indicated, as shown below

Step 6. As in above display if check mark exists with missing library, uncheck it and click OK

Step 7. Exit and save the original Excel file.

Now check to ensure respective functions are working properly.

Automate Task with Folder Actions

Turn on Folder Actions globally

To use Folder Actions, you must first turn this feature on globally. To do this, right-click or Control-click on any folder and choose Services -> Folder Actions Setup. (If you only have a few Services, you may not have a Services menu and will instead see the Folder Actions Setup menu item at the bottom of the contextual menu.) When you choose Folder Actions Setup, a small window opens showing a list of AppleScripts. Select Enable Folder Actions in the window and then quit (Command-Q).

Get alerted to incoming files

Now, let’s apply a simple, useful folder action to one of your folders. If you share files with others over a network, your colleagues may deposit files in your Mac's built-in Drop Box folder. But how do you know when a new document has arrived? Add a Folder Action that displays a dialog box whenever a new file is added to this folder.
To do this, first go to your Public folder. You’ll find it inside your home folder—the one with the house icon. (Or, in the Finder select Go -> Go To Folder and type ~/Public/). Right-click or Control-click on the Drop Box folder inside, choose Folder Actions Setup, click on “add - new item alert.scpt,” and then click on Attach.


Let’s try this out. Take any file and place it inside this folder. Within a few seconds you should see a dialog box telling you how many new items were added to the folder. This dialog asks if you would like to view these items. Click on Yes to open a window showing the files, or click on No to dismiss the dialog box. You may not need to see the files right away, but now you know that they have been added.

Once you attach the Folder Action to your Drop Box folder, you'll see an alert like this every time someone puts something in the folder.

Another way to use this same script is with your Dropbox folder. If you share files using Dropbox’s shared folders, you may want to know when you receive new files. Dropbox offers “desktop notifications”—floating alerts—but they fade away after a few seconds. Attach the same script we used above to a shared folder and you’ll see an alert whenever Dropbox downloads new files to that folder. Note that this only works when an item is added to the folder itself, not when someone adds an item to one of its sub-folders. If you have a lot of sub-folders in your shared folder, you can apply the same script to each of them to get alerts for all of the folders.

Explore OS X’s other built-in actions

OS X includes a handful of folder action scripts in the /Library/Scripts/Folder Action Scripts folder. Let’s look at a couple of them and see how they can save you time.

In this folder, you’ll see a number of scripts that can act on graphics. For example, there are three scripts that can automatically convert image files to JPEG, PNG or TIFF format. Let’s say you have a blog, and you want all your graphics to be in JPEG format. Create a folder somewhere and attach the “image - Duplicate as JPEG.scpt” script to it. Every time you add an image file to that folder, it will be immediately converted.

There’s a nifty script if you often open a lot of folders within a specific folder. As you know, closing all those windows can be annoying. If you attach the “close - close sub-folders.scpt” script to a folder, any sub-folders that are open will be closed when you close the top-level folder. This is useful if you have projects that require you to access files in a lot of sub-folders.

Turn off Folder Actions

If you ever want to turn off Folder Actions for specific folders, you can access the Folder Actions Setup applet as described above by clicking on any folder. Dismiss the list of scripts, and you’ll see a list of those folders for which you’ve set Folder Actions, and which scripts you’ve attached to them. Turn off any of these by unchecking them, or delete any folder or script by selecting it and clicking on the minus button.

In this window, you can see all folders that have Folder Actions attached to them, and which scripts they are set to run.

source: www.macworld.com

Skype Meeting control is not displayed on Outlook 2016

1. Start Outlook.
2. On the File menu, click Options.
3. In the navigation pane, click Add-Ins.
4. On the Manage menu, select COM Add-Ins, and then click Go.
5. In the COM Add-Ins dialog box, select the Skype Meeting Add-in for Microsoft Office 2016 option, and then click OK.

If you do not see the Skype Meeting Add-in for Microsoft Office 2016 entry in the COM Add-Ins dialog box, click here for the resolution. The entry should be displayed as it is in the following screen shot:

More Information:

Registry Key to enable or disable Skype Meeting Add-in

When you manually enable or disable the Skype Meeting Add-in for Microsoft Office 2016 add-in by using the COM Add-Ins dialog box (by using the steps in the "Resolution" section), the following registry data is updated:

Key: HKEY_CURRENT_USER\Software\Microsoft\Office\Outlook\Addins\UcAddin.LyncAddin.1
DWORD: LoadBehavior
Value: 3 = add-in is enabled, 2 = add-in is not enabled

"Skype Meeting Add-in for Microsoft Office 2016" entry is missing in COM Add-Ins

If you do not see the "Skype Meeting Add-in for Microsoft Office 2016" entry in the COM Add-Ins dialog box in Outlook, the add-in may not be correctly configured in the HKEY_LOCAL_MACHINE hive of the registry. In this situation, follow these steps.

Important Follow the steps in this section carefully. Serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration in case problems occur.

To resolve this issue, examine the applicable registry subkey for the Skype Meeting Add-in for your installation of Microsoft Office 2016.

Note These steps apply to both the 32-bit Windows client with Office 32-bit (Click-to-Run installation) and the 64-bit Windows client with Office 64-bit (Click-to-Run installation)

1. Click Start, type regedit in the Start Search box, and then click OK.
2. In Registry Editor, locate one of following subkeys, as applicable to your installation of Microsoft Office:
    
   • For 32-bit Windows client with Office 32-bit (Click-to-Run installation) or 64-bit Windows client with Office 64-bit (Click-to-Run installation):
     
     HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Registry\Machine\Software\Microsoft\Office\Outlook\Addins\UcAddin.LyncAddin.1
   • For 64-bit Windows client with Office 32-bit (Click-to-Run installation):
     
     HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Registry\Machine\Software\Wow6432Node\Microsoft\Office\Outlook\Addins\UcAddin.LyncAddin.1
   • For 32-bit Windows client with Office 32-bit (MSI installation) or 64-bit Windows client with Office 64-bit (MSI installation):
     
     HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Outlook\Addins\UcAddin.LyncAddin.1
   • For 64-bit Windows client with Office 32-bit (MSI installation):
     
     HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Outlook\Addins\UcAddin.LyncAddin.1
3. In the details pane, double-click LoadBehavior. If the value in the Value data box is not 3, change it to 3, and then click OK.

How To Add Additional Mailbox To Outlook 2016

1. To add another mailbox, launch Microsoft Outlook 2016 then click the File tab > click Info tab > Account Settings.

2. In Account Settings, select your current Mailbox and click Change.

3. On the next screen select More Settings.

4. Select the Advanced tab and click the Add button.

5. Type in the name of the mailbox then Click OK.

6. Once the name of your mailbox is created, click Add and Apply.

7. Finish out the wizard by clicking Next, and then Finish on the Change Account screen.

8. Close out of the Account Settings screen, and then select your new mailbox in the mail pane to populate it with your messages.

Troubleshooting:

If you are unable to add a mailbox, these could be some reasons:

• The administrator might not have permitted access. If so, contact them for further instructions and assistance.
• You entered an incorrect name for the mailbox; again, contact your administrator.
• The password has expired. If you have access to Outlook Web Access, try signing in and update your password then try signing in again.
• If you are an Office 365 user, make sure a license is assigned to your account to access the mail server.

How to import Sticky Notes from Windows 7 to Windows 10

Most of us are familiar with the classic Sticky Notes which are present in Windows 7, Windows 8, Windows 8.1 and up to Windows 10 v1511. However, In Windows 10 v1607 and later, Microsoft decided to convert the legacy Sticky Notesprogram to a UWP app, and this is what we are using currently on Windows 10.

1. On your Windows 7 machine, navigate to the following folder:

   %AppData%\Microsoft\Sticky Notes

2. Save the StickyNotes.snt file found within to an external backup device.
3. On your Windows 10 machine, close all instances of Sticky Notes and open the following folder:

   %LocalAppData%\Packages\Microsoft.MicrosoftStickyNotes_8wekyb3d8bbwe\LocalState

4. Create a new subfolder named Legacy within that folder.
5. Inside the Legacy folder, restore your StickyNotes.snt file and rename it ThresholdNotes.snt.
6. When you start the Sticky Notes app, your legacy content will be imported automatically.

How to reset Sticky Notes app:

Open Settings > Apps > Sticky Notes > Advanced Options. Press the Reset button. The app will be reset to default, and all app data will be deleted as well.

How to Convert local user into Active Directory network user in MAC computers

1. First ensure that the local mac user account password matches the password for the AD account that you want to migrate to.

2. Log into the computer under any Admin account other than the account that needs to be migrated.

 
3. Go to System Preferences -> Users and Groups -> and click on Login Options 

4. Authenticate to unlock Preference Pane. 

5. Click the 'Edit' or 'Join' button next to Network Account Server. 

6. Click 'Open Directory Utility' 

7. In Open Directory Utility, authenticate as an admin and go to the Edit menu and enable the Root user if not already enabled. Set a password for the root user if not already set. 

8. If you have already added the computer to the domain and configured option to create mobile account at login, close Directory Utility and go back to Users & Groups in System Preferences and continue to next step. 
If you have not bound computer to domain, double click 'Active Directory' in the Directory Utility. Click the triangle to the left of the window to expand the Active Directory options. Type in the domain name and click Bind. Authenticate with appropriate credentials. Choose create mobile account at login and then click OK. Continue back to Users & Groups in System Preferences and continue to next step. 

9. Select the local user account that you want to migrate to an AD account and choose Delete (-). 

10. At the Delete prompt, select option to 'Don't change the home folder (the home folder remains in the user folder). This will rename the user folder by adding '(Deleted)' at the end of the folder. Click 'Delete User' 

11. Log out of the computer. 

12. At login screen, select Other… and log into computer with AD account and if prompted, select the option for 'Create Mobile Account'. Skip any configuration prompts upon login. 

13. Log Out of AD account and log back in as root. 

14. Navigate to Users folder/new AD user folder and delete new AD user folder. Restart computer, log back in as root, and empty trash. 

15. Rename the old user folder. Go the the user folder and delete the '(Deleted)' and any spaces from the folder name. The name of the user folder needs to match the AD username. 

16. Select the User folder and choose Get info. 

17. Unlock Permissions 

18. Click + and add Network User and type in and select the correct AD user and click ok. 

19. Set the user with Read, Write permissions. Select user, click gear and choose 'Make user owner' 

20. Click + and add Network Groups and add 'Domain Users' 

21. Set 'Domain Users' group permissions to be Read Only. 

22. Delete 'Staff' group 

23. Under the 'Name' column in the 'Sharing Permissions:' section, you will see an owner account listed and under the 'Name' column, it may read 'Fetching'. Select it and delete this entry. Go to gear and select 'Apply to Enclosed Items'

24. Log out as root and log in as AD user. 

25. Account migration should now be complete. 

26. Go back to Directory Utility under System Preferences and disable the root user.

How to export an Outlook profile

To move your accounts, do this:

> start

> run

> type regedit

regedit: Search for: 

Outlook 2010:

HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows Messaging Subsystem\Profiles\Outlook 

Outlook 2013:

HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Outlook\Profiles

Outlook 2016:

HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Outlook\Profiles

and export it.

After you import it on to the new PC, you will have the enter the passwords for those e-mail accounts.

How to Clear Your Scratch Disk and Photoshop Cache on Mac

If you are a macOS user who regularly works in programs like Adobe Premiere Pro, Final Cut Pro and Adobe Photoshop, you’ve probably encountered errors relating to a "scratch disk." The most common error is "could not initialize Photoshop because the scratch disks are full".

What is a scratch disk?

Scratch disk is your hard drive space used by Photoshop as a virtual memory when there is not enough RAM to complete a task. Photoshop allows you to assign several scratch disks: that way, it has more space at its disposal.

When working with large images and lots of layers, Photoshop is secretly chewing up your Mac’s space by rapidly creating a mountain of project temp files.

What to do when your scratch disks are full?

1. Clear your Photoshop cache

Photoshop has an in-built solution for deleting specific Photoshop caches. When these pesky caches aren’t removed automatically by the program, they can grow and take up a lot of space on your scratch disk.

To use this tool simply enter Photoshop in Mac and with an image open:

• Click the Edit menu button.
• Hover your mouse over "purge" to reveal 4 different options.
• Undo, Clipboard, Histories, All. If an item is greyed out, that means it has already been deleted.
• Select the specific item you want to delete or select "all" to delete all of your caches.
• You will be warned that the purge cannot be undone, so make sure you don’t need a previous version of one of your projects and then click OK.

2. Delete your temp files

If the in-built solution on Photoshop doesn’t do the job for you, let’s hunt down the culprits manually. Look for files on your Mac that begin with “pst” extension and then a string of numbers followed by the file extension “.tmp”.

To make sure your scratch disk is empty, search for “Photoshop Temp” on your Mac and look within your entire Mac’s hard drive. Mac will take a couple of minutes to list down all temp files on Photoshop. Wait for a while until the entire list pops up on screen and then safely delete each and every temporary file from your Mac.

3. Clear your disk space

Once in a while it is advisable that you review the drive contents on your Mac. In this way, you can get rid of unneeded files and data and save a few extra chunks of storage space on your device. Head on to Apple Menu > About This Mac > Storage tab.

In the storage graph, you’ll see a “Manage” button. Tap on this option to optimize storage space on your Mac. Make the most of these Mac tools and save some additional storage space on your device.

4. Change your scratch disk

Follow these steps to change your scratch disk in Photoshop:

• Click on the Photoshop menu
• Go to Preferences and then Scratch Disk
• Tick the checkbox to select or remove a drive as the scratch disk
• Click OK
• Restart Photoshop

Adobe Indesign: Preferences and defaults

Set general preferences:

This section covers preference settings in the General tab of the Preferences dialog box. For information on other preferences, search for the appropriate setting.

Choose Edit > Preferences > General (Windows) or InDesign > Preferences > General (Mac OS), and then choose the type of preferences you want to specify.
In the Page Numbering section, choose a page numbering method from the View menu.
In the Font Downloading and Embedding section, specify a threshold to trigger font subsetting based on the number of glyphs a font contains. This setting affects font downloading options in the Print and Export dialog boxes.


In the When Scaling section, you can determine how scaled objects are reflected in panels and how the content of scaled frames behaves.



• Select Apply To Content if you want the point size to change when a text frame is scaled. If this option is selected when a graphics frame is scaled, the percentage size of the image changes, but the frame reverts its percentage to 100%.
• Select Adjust Scaling Percentage to display the original point size with the new point size in parentheses when you scale text. If this option is selected when you scale graphics frames, the percentage size of both the frame and image changes.


Click Reset All Warning Dialogs to display all warnings, even the ones you’ve already checked not to display. (As warnings appear, you can select a check box to prevent the warning from appearing again.)


Set defaults:

If you change settings when no documents are open, your changes set the defaults for new documents. If a document is open when you change settings, the changes affect only that document.

Similarly, if you change settings when no objects are selected, your changes set the defaults for new objects.

• Change default settings for new documents

• Close all documents.
• Change any menu items or panel or dialog box settings.

• Specify default settings for new objects in a document

With document open, choose Edit >Deselect All.


Change any menu items or panel or dialog box settings.

Restore all preferences and default settings:

When InDesign is behaving erratically, deleting preferences (also referred to as “trashing preferences” or “removing preferences”) often solves the problem.


It’s a good idea to make a backup copy of the preference files called InDesign Defaults and InDesign SavedData. Instead of removing your preferences, you can copy these backup files over the problematic corrupt preference files and not lose any customizations.
Mike Witherell provides a detailed list of which files are affected when you restore preferences in Adobe InDesign Presets (PDF, English only).


Do one of the following:



• (Windows) Start InDesign, and then press Shift+Ctrl+Alt. Click Yes when asked if you want to delete preference files.
• (Mac OS) While pressing Shift+Option+Command+Control, start InDesign. Click Yes when asked if you want to delete preference files.
Various program preferences and default settings are stored in the Adobe InDesign preferences files. These files, including the InDesign Defaults file, are saved each time you exit from InDesign. For manual deletion or renaming, the locations of the preference files are as follows:



• Mac OS
  InDesign SavedData
  Users/[user]/Library/Caches/Adobe InDesign/Version [version]/InDesign SavedData
  InDesign Defaults
  Users/[user]/Library/Preferences/Adobe InDesign/Version [version]/InDesign Defaults
• Windows XP
  InDesign SavedData
  \Documents and Settings\[username]\Local Settings\Application Data\Adobe\InDesign\Version [version]\Caches
  InDesign Defaults
  \Documents and Settings\[username]\Application Data\Adobe\InDesign\Version [version]
• Windows Vista or Windows 7
  InDesign SavedData
  Users\[username]\AppData\Roaming\Adobe\InDesign\Version [version]\Caches\InDesign SavedData
  InDesign Defaults
  C:\Users\[username]\AppData\Roaming\Adobe\InDesign\Version [version]\InDesign Defaults




font: https://helpx.adobe.com/indesign/using/setting-preferences.html