Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 TKendrick20
		
			TKendrick20
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Is it possible to create an extension where I could click a button and the extension would run and insert a text box at a certain location with a certain color and certain size?
Let me elaborate: If I have 7 sheets and want three text boxes in the same exact position and size on each page, but don't want to go through and manually do this on each sheet, could an extension be programmed so that it knows where to drop these text boxes on each page?
 
					
				
		
I think it easier to copy/paste rather than create a special extension or macro for this.
Create your three objects on one sheet, select all three, copy (Ctrl+C), go to another sheet, right-click, paste as Link, repeat on the other sheets.
Doesn't it work for you?
 
					
				
		
 TKendrick20
		
			TKendrick20
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I can only seem to copy one item at a time, and it always goes to the same place on the next page. I need it to be formatted based on what's already on that page.
 
					
				
		
 Alexander_Thor
		
			Alexander_Thor
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Extensions can't add objects into the core document.
You could add HTML elements into the browser at run time but they will be lost whenever you refresh the page.
As Michael suggests linked objects are the way to go in terms of maintainability.
If you want to automate creation of documents maybe macros could help you out, loop all the sheets and add the objects.
 
					
				
		
 TKendrick20
		
			TKendrick20
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		and how does one link objects?
 
					
				
		
 Alexander_Thor
		
			Alexander_Thor
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Copy a object, right click > 'Paste object as Link' or simply enter the same object id in the objects you want to link.
Then the objects will be linked, change it one place and it will propagate to all of the linked objects.
 
					
				
		
The advantage of the linked objects that are in fact "the same" object which exists in multiple places. If you change a property like text color or font size, it changes in all linked objects. But location on sheets can be different.
Object ID is the same for all linked objects.
(I don't know why you cant copy/paste multiple objects at a time. Make sure that you select multiple.)
